cancel
Showing results for
Did you mean:
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

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

I want to calculate 49/20 = 2.45

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: Matrix table visual dax for division

This solution is provided by  @Vvelarde

Thanks a lot.

Here is the pbix file

3 REPLIES 3
Super Contributor

## Re: Matrix table visual dax for division

@mehaboob557

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

Victor

Lima - Peru

Proud to be a Datanaut!

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?

Member

## Re: Matrix table visual dax for division

This solution is provided by  @Vvelarde

Thanks a lot.

Here is the pbix file

Announcements

#### 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!

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?

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

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