Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculated calculation based on logic

Account NameDateAmount
Rev12-Jun-18430
Exp13-Aug-17250
Margin2-Mar-170
Rev12 July 18400
Exp13-Aug-17300

 

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'

 

Regards

Hitesh

1 Reply

  • ibarrau's avatar
    ibarrau
    Super User
    7 years ago

    Hi. Can you explain a bit more your idea? i don't understand why <> marin or = margin both result in sum of amount. The third line should something like: (i think variables can help to get better undestanding)

    VAR amount_rev = CALCULATE ( 
    SUM (Table[Amount] ) ,
    Table[Name] = "Rev"
) 
VAR amount_exp = CALCULATE ( 
    SUM (Table[Amount] ) ,
    Table[Name] = "Exp"
)

RETURN
amount_rev - amount_exp

    Hope this helps

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.