Forum Discussion
Difference between two measures/rows
Something is wrong. What is Lay = "FC"? FC is the name of the measure. For Lay we have the entries Ist, FCI, FCII, FCIII, FIIII.
I think the best way is a PIVOT before. Makes it easier.
At the moment for quarter 2 it looks like following
What i want is the difference between IST - FC. But may i should pivot the table before when it is difficult via measure...
Essentially what you need to do is calculate the FC amount on the IST row and reverse.
You need to do this based on a unique identifier, which looks like it is KNT.
Measure =
VAR KNT = SELECTEDVALUE(Table[KNT])
VAR LAY = SELECTEDVALUE(Table[Lay])
Return
IF( Lay = "FC" ,
CALCULATE( [IST] , ALL(Table) , Table[KNT] = KNT Table[Lay] = "Ist") - [FC] ,
[IST] - CALCULATE( [FC] , ALL(Table) , Table[KNT] = KNT Table[Lay] = "FC")
)
Let me know if you need any more help .
/ J
Something is wrong. What is Lay = "FC"? FC is the name of the measure. For Lay we have the entries Ist, FCI, FCII, FCIII, FIIII.
I think the best way is a PIVOT before. Makes it easier.