04-21-2017 11:16 AM
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?
Solved! Go to Solution.