Display set of particular expressions based on dimension
I have a query. I am trying to create visualizations where in I have 5 drill down dimension sets which are added to master items.
I have created a pie chart by adding all these master item drill down dimensions as alternate dimensions to the chart.
I have created a variable with the list of measures. Each dimension will be applicable to only 2 measures.
To represent them in figures:
When DimA is selected in the chart, the variable drop down should show only Measure1 and MeasureA as selections, when DimB is selected in the chart Measure1 and MeasureB should be shown as selections in variable drop downs and so on