To calculate percentage based on specific columns in a matrix

[jesly_ajin]

Dear All,

Based on the below data I need another column named Percentage that calculates percentage as (Sum of 4 & 5 / Total ) * 100.

The below table is a matrix table. Kindly help.

@v-jianboli-msft Please help me.

[jesly_ajin · Accepted solution]

I found a resolution to this as below:

Measure =
VAR Count45_ = CALCULATE (
COUNT ( VW_DetailLookUp[Response] ),
FILTER (
ALLEXCEPT ( VW_DetailLookUp, VW_DetailLookUp[FileLocation], VW_DetailLookUp[Questions] ),
OR ( [Response]="4-Agree", [Response]="5-StronglyAgree" )
))
VAR CountAll_ = CALCULATE (
COUNT ( VW_DetailLookUp[Response] ),
ALLEXCEPT ( VW_DetailLookUp, VW_DetailLookUp[FileLocation], VW_DetailLookUp[Questions] ))
RETURN
IF (SELECTEDVALUE ( ResponseMaster[Response] ) = "Sum of 4 & 5",
Count45_,
IF (SELECTEDVALUE ( ResponseMaster[Response] ) = "Percent",
DIVIDE(
Count45_,
CountAll_, 0
) * 100,
COUNT ( VW_DetailLookUp[Response] )
))

[jesly_ajin]

@Arul I did create another measure. But it does not work as expected.

As in the below figure, I need the percentage calculated based on [Sum of 4 or 5] / Total.

Also, the below figure gives an idea of the measure I already have.

Kindly help.

[Arul]

@jesly_ajin ,

check this thread, this might help you.

https://community.powerbi.com/t5/Desktop/how-to-add-percentage-column-in-the-end-of-the-matrix-table... 

Thanks,

Arul

[jesly_ajin]

@Arul Thanks for the response.

[Arul]

@jesly_ajin ,

try this,

Percentage = 
VAR _allValues = CALCULATE(
    SUM(Table[columnvalue]),ALL(table))
VAR _result = DIVIDE([Sum of 4 & 5],_allValues)*100
RETURN _result

Thanks,

Arul