Calculated Measure

Anonymous — Thu, 22 Aug 2019 19:16:05 GMT

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 calculated measure based on the below logic

If the Account Name <> 'Margin' then Sum of amount

if the Account Name = "Margin' then Sum of amount =

Sum of Amount when account name is 'Rev' - Sum of Amount when account name is 'Exp'

Re: Calculated Measure

Stachu — Fri, 23 Aug 2019 07:13:06 GMT

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:

Measure	Positive	Negative
Margin	Rev	Exp
Margin2	Rev	Exp2

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

topic Re: Calculated Measure in DAX Commands and Tips

Calculated Measure

Re: Calculated Measure