GetSelectedCount() not working with IF function on dimension

[Sa_Rah]

I am using the following formula to identify whether or not to display some visualizations. I shall call it Formula 1:

((GetSelectedCount(DateLinkDate) + GetSelectedCount(LinkDate) + GetSelectedCount(YearLinkDate) + GetSelectedCount(MonthYearLinkDate) + GetSelectedCount(FinYearLinkDate)) > 0)

This is working fine if I select specific values of one of the mentioned dimensions e.g. FinYearLinkDate.

However if i have an IF() statement around say FinYearLinkDate  in another visualization, e.g.

=if(MonthYearLinkDate>'31/03/2019',if(MonthYearLinkDate <=MonthEnd(Addmonths(today(),-1)),FinYearLinkDate))

and I use this visualization to select the FinYearLinkDate, Formula 1 evaluates to 0 and no visualization displays.

Does anyone know why this is happening? 

Thanks

Sarah

[sasikanth · Accepted solution]

HI, 

Try below,

Since there is no dependency , move your calculated Dim Exp to script as a New filed and use it in fist expression. 

if(MonthYearLinkDate>'31/03/2019' and MonthYearLinkDate <=MonthEnd(Addmonths(today(),-1)) ,FinYearLinkDate) As NewMonthYearLinkDate,

((GetSelectedCount(DateLinkDate) + GetSelectedCount(LinkDate) + GetSelectedCount(YearLinkDate) + GetSelectedCount(MonthYearLinkDate) + GetSelectedCount(NewMonthYearLinkDate)+GetSelectedCount(FinYearLinkDate)) > 0)

Thanks, 

Sasi