Subtract value from total of other categories

[AshDil]

Hi, 

I have data as follows:

Seg	CAT	VALUE
East	A	100
East	B	200
East	C	300
East	D	200
East	E	300

Want to show a East segment value as 500 (i.e, Sum(cat A + cat B+ cat C+ cat D) - Sum(Cat E) = (100+200+300+200) - 300 = 500 )

Please help me to do

Thanks,

AshDil

[amitchandak · Accepted solution]

@AshDil , Try measure like

calculate(sum(Table[value]), filter(all(Table[CAT]), Table[CAT] in {"A","B","C","D"})) - calculate(sum(Table[value]), filter(all(Table[CAT]), Table[CAT] ="E") )

If needed remove all in filter