Matrix table visual dax for division

[mehaboob557]

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

[Vvelarde]

@mehaboob557

hi,in your table the count of quote number are 39.

Victor

[mehaboob557]

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?

[mehaboob557 · Accepted solution]

This solution is provided by  @Vvelarde

Thanks a lot.

Here is the pbix file