Subtract a top row value to another row from Matrix

jasonjklim — Fri, 05 May 2023 20:14:21 GMT

I am trying to establish a matrix table in PBI.

One of the calculation is subtracting a top row value to another row from a matrix.

For example,

I used DAX to do the samething.

Drivers value2 = VAR production = calculate(sum('Summary Data'[Value])/1000000, 'Expense Roll up Mapping'[Expense Layer 3] ="Production Labor") var adl2 = calculate(sum('Summary Data'[Value])/1000000, 'Expense Roll up Mapping'[Expense Layer 3] ="Associate Domestic Labor", ALL('Summary Data'[New BU]) ) var adl = calculate(sum('Summary Data'[Value])/1000000, 'Summary Data'[Expense RollUp_P&L] ="Associate Domestic Labor" ) return SWITCH(SELECTEDVALUE('Expense Roll up Mapping'[Expense Layer 3]), "Production Labor", IF(ISBLANK(production),0, production), "Associate Domestic Labor", IF(ISBLANK(adl2-production), 0 ,adl2-production))

However, the result is the following:

I guess that in matrix, my Associate Domestic Labor row in expense layer 3 can't subtract different rows' values, production from the same table.

Is there any way that I can get this?

Please advise.

Thank you.

topic Subtract a top row value to another row from Matrix in DAX Commands and Tips

Subtract a top row value to another row from Matrix