Forum Discussion

Back2Basics's avatar
Back2Basics
Resolver I
9 years ago
Solved

Display percentage in Matrix Preview

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

Need Help
  • Sean's avatar
    Sean
    9 years ago

    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
)

4 Replies

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    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
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

         

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