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