Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure with variable filter based on slicer

Hi All,

 

I want to calculate the sum of sales with filter on current year:

 

Current situation:

€ Sales CY = calculate([€ Sales];filter(Calender;Calender[Year]='Year variable'[CY]))
 
I would like to make the filter value variable, based on the selected value in a slicer, slicer values: CY, YTD, MTD, Current Month etc. So something like this: 
 
€ Sales = calculate([€ Sales];filter("slicer value")) 
 
How can this be done? 
 

1 Reply