Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |