Alternate State Independent Filter with calculation condition is not working
Hi,
I am trying to achieve a scenario where there are 2 similar filters (named, Country) one with the default state while the another with an alternate state 'Compare 1'.
I want to filter a table based on both the filters and the table is is in 'Compare 1' alternate state already. It is working absolutely fine with {$*[Compare 1]} in the prefix of the expression in Measure of the Table.
But the challenge is that the table is also applied with the calculation condition which hides it until there is a selection in the Country Filter.
Now, with the calculation condition applied, when I am selection values in the filter with the 'Compare 1' state, the table is appearing and showing the correct value. But while selecting the values in the default state, the table is not showing up.
Any solution ?
Also tried applying the {$*[Compare 1]} in the Calculation Condition expression of the KPI but no success.