cancel
Showing results for
Did you mean:
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:

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)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team

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

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.
2 REPLIES 2
Highlighted
Community Support Team

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

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.
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!

Announcements

#### 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

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

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)