Add a filter when calling a variable $(Variable) in Set analysis

[luisccmm]

If I need to add the filter Year=2019 to the following variable in Set analysis?

$(Variable1)

What I am trying to do is something like this, but don´t know how to write it...

$({<Year={"2019"}>}Variable1)

Thanks in advance!!

[Kushal_Chawda]

If you want your variable always on latest year, create variable

vYear = max(Year)

then use set analysis like

=Sum({<Year={$(vYear)}>}Sales)

[Kashyap_R]

Hi 

try like this

Sum({<Year={"2019"}>},$(Variable1)) 

Replace aggregation function according to your requirement

hope this helps 

Thanks

[luisccmm]

Thanks for your help @Kashyap_R , you seem to understand what I was looking for!!

But I´ve get an error, when I use your formula it says ')' expected.

[Kashyap_R]

Hi

Try this 

Sum({<Year={'2019'}>}$(variable))

just syntax error

Hope this works and solve your problem

Thanks

[Kushal_Chawda]

Based on your expression I can see that your variables have Count functions. You may need to use Aggr function to work this properly

=Sum({<Year={2019}>} aggr($(vNet Sales)-$(instaladas),Dimension1,Dimension2))

Where, Dimension1 & Dimension2  are the Dimensions you are having in the chart where you are using this expression.