cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jhoyskee Frequent Visitor
Frequent Visitor

How to calculate (row) percentage in matrix?

Hi I am struggling with getting the percentages in powerbi. I have seen percentage calculation in columns but not in rows in a matrix table.

 

In my Excel it looks like this:

Capture.PNG

 

 

I do not know how to calculate the %approved (which is the percentage of total approved from grand total) . is it possible to compute for that and have it as a row and not a column (coz im finding percentage calculation mostly for columns)

 

Capture2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: How to calculate (row) percentage in matrix?

@jhoyskee,

 

You may add the following measure.

Measure =
IF (
    HASONEVALUE ( Table1[Status] ),
    SUM ( Table1[Value] ),
    FORMAT (
        DIVIDE (
            CALCULATE ( SUM ( Table1[Value] ), Table1[Status] = "Approved" ),
            SUM ( Table1[Value] )
        ),
        "0.00%"
    )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: How to calculate (row) percentage in matrix?

@jhoyskee,

 

You may add the following measure.

Measure =
IF (
    HASONEVALUE ( Table1[Status] ),
    SUM ( Table1[Value] ),
    FORMAT (
        DIVIDE (
            CALCULATE ( SUM ( Table1[Value] ), Table1[Status] = "Approved" ),
            SUM ( Table1[Value] )
        ),
        "0.00%"
    )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

jhoyskee Frequent Visitor
Frequent Visitor

Re: How to calculate (row) percentage in matrix?

thanks @v-chuncz-msft this really works! 

 

however though i cannot put in the same matrix table. its not possible right!

but anyways thank you very much!

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)