cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mehaboob557 Member
Member

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

 

test d.PNG

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

1 ACCEPTED SOLUTION

Accepted Solutions
mehaboob557 Member
Member

Re: Matrix table visual dax for division

This solution is provided by  @Vvelarde

 

Thanks a lot.

 

Here is the pbix file

View solution in original post

3 REPLIES 3
Vvelarde Super Contributor
Super Contributor

Re: Matrix table visual dax for division

@mehaboob557

 

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

 

Victor




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




mehaboob557 Member
Member

Re: Matrix table visual dax for division

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 Member
Member

Re: Matrix table visual dax for division

This solution is provided by  @Vvelarde

 

Thanks a lot.

 

Here is the pbix file

View solution in original post

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors