Calculate measure sum based on 2 filter selection

[cbouichi]

Hello everybody,

I try to sum a column based on a filter selection on 2 other columns in the same table.

i try this but didnt get it too work;

F1 CARD = CALCULATE(SUM('EAM U5WORM'[Kostenplotten] FILTER('EAM U5WORM';'EAM U5WORM'[KANS] = 300 && 'EAM U5WORM'[Waarde] = 0)

Kind regards,

CHaraf

[HotChilli · Accepted solution]

Try this

F1 CARD = CALCULATE(SUM('EAM U5WORM'[Kostenplotten]), 'EAM U5WORM'[KANS] = 300 , 'EAM U5WORM'[Waarde] = 0)

[cbouichi]

@HotChilli  thank you for your reply,

I tried your solution but i didnt work for me.

Maybe you know why?

[cbouichi]

instead of a , i use ; and then it worked for me.

Thank you @HotChilli