Combining CALCULATE Measures

[SimonNU]

Hi Guys

Can you please help me combine the below measures into one?

Expense 1: CALCULATE(SUM('COMBINED GL DATA'[CURRENT PERIOD]),'PROFIT AND LOSS DESCRIPTION MAP'[PL Description]="Main Expense 1")
Expense 2: CALCULATE(SUM('COMBINED GL DATA'[CURRENT PERIOD]),'PROFIT AND LOSS DESCRIPTION MAP'[PL Description]="Main Expense 2")
Expense 3: CALCULATE(SUM('COMBINED GL DATA'[CURRENT PERIOD]),'PROFIT AND LOSS DESCRIPTION MAP'[PL Description]="Main Expense 3")
Gross Income: CALCULATE(SUM('COMBINED GL DATA'[CURRENT PERIOD]),'PROFIT AND LOSS DESCRIPTION MAP'[PL Description]="Gross Income")

Currently, I simply do [Expense 1]+[Expense 2]+[Expense 3]+[Gross Income] but I'd prefer to have the 1 formula instead of 5.


Simon

 

[scottsen]

While I prefer the way you have it, (thought I might consider a base measure for just that SUM())...

Total := CALCULATE([Measure], MAP[Desc] = "Exp1" || MAP[Desc] = "Exp2" || ...

|| is the "OR" operator, just string 4 clauses together and you are good to go.