Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Mahaboob Basha T]

Hi All,

I am trying to write the dax function for the divide(total/distinctcount(quoteNo))

Below  img shows only satisfying condition vesrion <=1.0 and accepts validation =1

 
For example,

if i am having total 40 and quoteNo count is 20 .

I want to calculate 40/20 = 2

I am sharing my pbix file here . Please help me how can i achieve this 

Thanks a ton in advance

——————————
Mahaboob Basha T
——————————

[Tara Prasad Gumansingh]

Hi Mahaboob,

You should create a column first like the below one

Column = IF(‘sample'[version] <= 1.0,1,BLANK())

Then create a measure like the below

Measure = CALCULATE(COUNT(‘sample'[quoteNo]),FILTER(‘sample’,’sample'[Column] = 1))

Then you can divide Measure / distinctcount of quoteNo

—

Regards,

Tara Prasad Gumansingh

Bangalore

——Original Message——

Hi All,

I am trying to write the dax function for the divide(total/distinctcount(quoteNo))

Below  img shows only satisfying condition vesrion <=1.0 and accepts validation =1

 
For example,

if i am having total 40 and quoteNo count is 20 .

I want to calculate 40/20 = 2

I am sharing my pbix file here . Please help me how can i achieve this 

Thanks a ton in advance

——————————
Mahaboob Basha T
——————————

[Mahaboob Basha T]

Hi prasad,

Thank you for the response?.

But, i want the total of Status (Comfirmed, draft, published) i.e 49.I followed as you suggested but, i am getting 209 but here i have 49.

I am sharing my pbix file in the attachment of the reply. Please check and suggest me how can i achieve this.

Thanks in advance

——————————
Mahaboob Basha T
——————————
——————————————-