Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @fanisgeorg ,
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
Hi @fanisgeorg ,
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
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |