Dynamic selection - issue with calculated dimension

[#1]

Hi,

The user is selecting a score of a customer from a list of 5 (A,B,C,D,E).

After each selection, the chart has to show only the customers that have such as score, taking into account all the others scores too.

Another words, it's like using the Exists function but in the chart.

I was trying to use the FieldIndex in a calculated dimension, but it doesn't work. Or, maybe my syntax is wrong:

=if ($(vShowRange) = 1 and FieldIndex('RangeValue',$(vRangeValue))>0, [Customer Name])

Thanks!

[Gysbert_Wassenaar · Accepted solution]

I think you're looking for indirect set analysis. See this discussion. If you post some sample data we can help you find a solution that fits your problem.

[#3]

Hi,

It sure did the job. But what I'm missing is that only the chart is impacted.

Another words, in other objects the selection is not updated.

So, after selecting a specific score,  a customer might not be included in the chart (as desired),

but would not be "greyed" in a corresponding list box.

Is this expected behavior?

Thanks!