Forum Discussion

mehaboob557's avatar
mehaboob557
Resolver III
8 years ago
Solved

Matrix table visual dax for division

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

 

Here i am having total 49 and quoteNo count is 20 .

 

I want to calculate 49/20 = 2.45

 

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

 

Thanks a ton in advance

3 Replies

    • mehaboob557's avatar
      mehaboob557
      Resolver III

      Hi Vvelarde,

       

      Thanks for the response.

       

      I have just shown some numbers as an example.

       

      I need to divide with the total by count of quote

       

      how can i achieve this?