Set Expression

[hargovind_singh]

Hi Guys,

I got one issue in set analysis in QS,   I have a filter pane for year selections so what i am trying to do is when i select any year from filter pane(Year) lets say I selected 2020 then my sum expression should show the sum of 2020 amount.

my sum expression is ->

Sum({<Year1= {$(=GetFieldSelections([=Year1]))}>}[Amount Millions])

where Year and Year1 are columns in dataset and Year column having Data like FY19,FY20(fiscal year) etc... and Year1 is having data like 2019,2020,2021.

Year1 is used for filter pane.

Bt the issue is when i am selecting any year , it is not showing the sum of amount instead it is showing 0.00

pls help .

Thanks 

[Saravanan_Desingh]

Try this

Sum({<Year1={'$(=GetFieldSelections(Year1))'}>}[Amount Millions])

[md_anasabbasi]

Is your Year1 field is in the same table as [Amount Millions] so you wouldn't need to mention anything in your set expression, upon selection it should show the desired value with

sum([Amount Millions])

If not in the same table, maybe you can show us the data model(or explain)

If there are two fields of Year with  similar values but different table not connected to each other you could use

sum(Year=P(Year1)[Amount Millions])

i.e. from your year field you could extract 2019, 2020 from FY19 or FY20.