Display percentage in Matrix Preview

[Back2Basics]

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

[Sean · Accepted 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
)

[Back2Basics]

Hi @Sean

Many thanks for the reply. This has worked brilliantly.

[Anonymous]

Hello friends
It seems to me that did not solve the problem.
I want the total to be as recorded in the picture.
Thanks

[Anonymous]

The formula is  (390 - 33.7) / 390 = 91.3%