cancel
Showing results for
Did you mean:
Frequent Visitor

## Calculating percent of column in matrix with filters

I have a tabled called ABC, and that I want to use to produce a matrix that looks like this:

Ask     Rating     # Proposals   % of Proposals

Entry     High         6                30%

Entry     Medium   10              50 %

Entry     Low            4              20 %

Entry     Total          20            100%

Luxury   High          1                20%

Luxury   Medium     3               60%

Luxury   Low           1                20%

Luxury   Total          5             100%

The % of proposals column should calculate the % for that grouping.  I used the following measure to calculate the percentage:

% Proposals = DIVIDE(CALCULATE(DISTINCTCOUNT(ABC[Prop ID Number])), CALCULATE(DISTINCTCOUNT(ABC[Prop ID Number]), ALLEXCEPT(ABC,ABC[Ask])))

This worked fine, until I added additional product types to the ABC table. I have a page level filter for the product type, but the % shown in the matrix are now incorrect, and calculated off the entre proposal base, not just the proposals for this product type.  Any ideas how to fix?

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

## Re: Calculating percent of column in matrix with filters

Solved. The answer was to add: ABC[Product]="Name" in the CALCULATE statement to include the filter needed.

2 REPLIES 2
Frequent Visitor

## Re: Calculating percent of column in matrix with filters

Solved. The answer was to add: ABC[Product]="Name" in the CALCULATE statement to include the filter needed.

Highlighted
Microsoft

## Re: Calculating percent of column in matrix with filters

Hi @braypa,

Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread?

Regards

Announcements

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### November 2019 Community Highlights

Get an overview of the events and great community content from November.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)