Forum Discussion

Back2Basics's avatar
Back2Basics
Icon for Resolver I rankResolver 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...
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
)
Sean's avatar
Sean
Icon for Community Champion rankCommunity 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
)
Back2Basics's avatar
Back2Basics
Icon for Resolver I rankResolver I
9 years ago

Hi Sean

 

Many thanks for the reply. This has worked brilliantly.

  • 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

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