Calculating percent of column in matrix with filters

[braypa]

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?

[braypa · Accepted solution]

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

[v-ljerr-msft]

Hi @braypa,

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

Regards