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

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

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!