How to calculate (row) percentage in matrix?

[Anonymous]

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)

[v-chuncz-msft · Accepted solution]

@Anonymous,

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%"
    )
)

[Anonymous]

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!