Forum Discussion

Anonymous

Not applicable

6 years ago

undefined

So I habe data like this. Date. Type Value 19/1/2020 A 12 19/1/2020 B 20 20/1/2020 A 40 20/1/2020 B 20 . . I want to calculate A - B and plot it on a graph. I can't write Type = A in a formul...

stevedep

Memorable Member

6 years ago

Hi,

This is what I have, should be pretty robust.

Measure = 
var _CT = CALCULATETABLE(SUMMARIZE('Table';'Table'[Type];'Table'[Date]);ALLEXCEPT('Table';'Table'[Date]))
var _AValue = CALCULATE(SUM('Table'[Value]);FILTER(_CT; 'Table'[Type]= "A"))
var _BValue = CALCULATE(SUM('Table'[Value]);FILTER(_CT; 'Table'[Type]= "B"))
return 
_AValue-_BValue

Looking for this? Please mark as solution. Helpful? Thumbs up would be great.

Kind regards, Steve.