Forum Discussion
Percentage calculation
Hello everyone
I need to create a measure to calculate the percentage of the projet count 49/66 for the two matrix table below. The measure in both table is the same (Count ProJects), but the values are different because different filters are applied to each matrix table.
Someone able to help?
Thanks
Fanis
Hi Anonymous ,
Please try this measure:
Result =
DIVIDE(SUM(PROJECTCOUNT), CALCULATE (SUM(PROJECTCOUNT), ALLSELECTED()))
Also, click on the measure, and select "show as values" and check if it is "percent of column total"
Regards,
Truptis
2 Replies
Hi Anonymous ,
Please try this measure:
Result =
DIVIDE(SUM(PROJECTCOUNT), CALCULATE (SUM(PROJECTCOUNT), ALLSELECTED()))
Also, click on the measure, and select "show as values" and check if it is "percent of column total"
Regards,
Truptis