cancel
Showing results for
Did you mean:
Resolver IV

## 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
Resolver IV

## Re: Matrix table visual dax for division

This solution is provided by  @Vvelarde

Thanks a lot.

Here is the pbix file

3 REPLIES 3
Community Champion

## Re: Matrix table visual dax for division

@mehaboob557

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

Victor

Lima - Peru
Highlighted
Resolver IV

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

Resolver IV

## Re: Matrix table visual dax for division

This solution is provided by  @Vvelarde

Thanks a lot.

Here is the pbix file

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors