help with the dax expression to calculate depending on dim value ?

[ashmitp869]

Hi all,

How can I achieve

when [Service Group Level 0] is "REVENUE" then [Actual Amount] 

when  [Service Group Level 0] is "COSTS + OVERHEADS" then [Cost Amount] 

[ashmitp869]

getting an error. what can be the reason ?

[lbendlin]

a measure needs an aggregation.  use MAX([Service Group Level 0])  , for example.

[lbendlin · Accepted solution]

You can use nested IFs, or the syntax sugar version SWITCH.

Result = SWITCH([Service Group Level 0],"REVENUE",[Actual Amount],"COSTS + OVERHEADS",[Cost Amount])