MATRIX INCORRECT SUBTOTAL BECAUSE ADVANCE NESTED MEASURE

[bryanrendra]

Hi I really need your help, I would like to calculate percentage from 2 calculated measure. however the percentage measure is not summing each row percentage instead applying the formula on the subtotal here is the document:

 The percentage is showing 10% because the formula applied there , instead i just want to calculate 6%+3%+6$%+4%+8%+5%+4%+4%+5%+7%+4%+4%+3%=63%

here is the formula for percentage:

Percentage = IF(

DIVIDE(([LatestPrice Excise]-[PreviousPrice Excise]),[PreviousPrice Excise],0)=0,0,IF([LatestPrice Excise]=0,0,ABS((DIVIDE(([LatestPrice Excise]-[PreviousPrice Excise]),[PreviousPrice Excise],0)))))

the reason i do IF statement because the latest price of the book might be 0 because there is not stock on warehouse.

 

[amitchandak · Accepted solution]

@bryanrendra , Try this out

DIVIDE(abs(([LatestPrice Excise]-[PreviousPrice Excise])),[PreviousPrice Excise],0)

Or Sumx(Values(Table[Group]),[Percentage])

Here group is your rows/axis/group by you used

[bryanrendra]

Hi your solution is fully work, thank you so much Mr. Amitchandak

[bryanrendra]

thank you for your answer, but it gave me 0 % to the all of the rows

[AntrikshSharma]

Maybe you could try this:

Percentage =
SUMX (
    VALUES ( Table[ColumnInYourVisual] ),
    IF (
        [LatestPrice Excise] = 0,
        0,
        DIVIDE (
            ABS ( [LatestPrice Excise] - [PreviousPrice Excise] ),
            [PreviousPrice Excise],
            0
        )
    )
)

[lbendlin]

Read up on the concepts of SUMX and HASONEVALUE.

[bryanrendra]

I am really new to power bi, could you help me please?