Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Back2Basics
Helper IV
Helper IV

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
Sean
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
Sean
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
)

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.