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.
Hi
I'm trying to create a view using the Matrix Preview to display the perecentage of 'Fail' and 'Pass' for each row.
Pass and Fail are the only two values available in a column called 'KPI 1' - a calculated column base don another column. I've hidden my category details, as this is sensitive, but should give an idea of what I have currently:
So for the first rowI would like to see the Fail percentage as 50.6% and Pass percentage as 49.4%
Any help would be apprecaited.
TIA
Henry
Solved! Go to Solution.
Right-Click on the field you have in the Values area of the Matrix Preview => Show Values As => Percent of Row Total
But if you want a Measure which you can actually format (number of decimals) use this Measure instead
% of Row Total Measure = DIVIDE ( SUM ( 'Table'[Score] ), CALCULATE ( SUM ( 'Table'[Score] ), ALLSELECTED ( 'Table'[KPI 1] ) ), 0 )
Right-Click on the field you have in the Values area of the Matrix Preview => Show Values As => Percent of Row Total
But if you want a Measure which you can actually format (number of decimals) use this Measure instead
% of Row Total Measure = DIVIDE ( SUM ( 'Table'[Score] ), CALCULATE ( SUM ( 'Table'[Score] ), ALLSELECTED ( 'Table'[KPI 1] ) ), 0 )
Hello friends
It seems to me that did not solve the problem.
I want the total to be as recorded in the picture.
Thanks
The formula is (390 - 33.7) / 390 = 91.3%
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |