Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculated Measure

Account Name Date Amount Rev 12-Jun-18 430 Exp 13-Aug-17 250 Margin 2-Mar-17 0 Rev 12 July 18 400 Exp 13-Aug-17 300   I have a table where I need to create a calcul...
Stachu's avatar
Stachu
Community Champion
7 years ago

try this

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Account Name] ) = "Margin",
    CALCULATE ( SUM ( 'Table'[Amount] ), 'Table'[Account Name] = "Rev" )
        - CALCULATE ( SUM ( 'Table'[Amount] ), 'Table'[Account Name] = "Exp" ),
    SUM ( 'Table'[Amount] )
)

if you have more cases like this it may be better to embed the logic in a new table, e.g. like this:

MeasurePositiveNegative
MarginRevExp
Margin2RevExp2

something similar to what's described here:
https://community.powerbi.com/t5/Desktop/Create-calculated-row/td-p/440613