Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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%
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |