cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

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:

 

Capture.JPG

 

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

1 ACCEPTED SOLUTION
Community Champion
Community Champion

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
)

View solution in original post

4 REPLIES 4
Community Champion
Community Champion

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
)

View solution in original post

Hi @Sean

 

Many thanks for the reply. This has worked brilliantly.

 

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

percent.png

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors