Filter table by 2 conditions and then sum values

[kap_55]

Hi,

I would like to filter based on Category but category changes each year. Can I do that in measure?

I hope it's clear from the picture.

Thanks.

B.

[Anonymous · Accepted solution]

@kap_55 Create following measure in source table

Measure = 
VAR _year = MAX(Source[Year])
VAR _color = CALCULATETABLE(VALUES(Mapping[Category]),Mapping[Year]=_year)
RETURN CALCULATE(SUM(Source[Value]),Source[Category] IN _color)

As per my understanding 2017 sum of value should be 7. 

[kap_55]

Works awesome. Thanks.

[kap_55]

Yes. My mistake 🙂

Let me try your solution.