Create Measure That Affected from one specific Filter

[IgorGol]

Hi,

I have one Measure lets do it simple : sum(Revenue)

Also Have some filters : Year, Month , Department

What Should I write in set analysis (Measure) so it will be affected  only from one specific Filter (Year)

Thanks a lot!

[Vegar · Accepted solution]

I believe this will help you

Sum( {<Month,Department>}Revenue)