Measures in Drop down list.

[axavi1]

Hi,

I have few measures that I have successfully put into a drop down list, but having difficulty to put aggregated measures.

The aggregated measure is a distinct count of a category. In calculated item, there is no option for aggregated measures. 

Any insight.

Please help.

[Rahul_SAS]

but as i know, your cant use numeric variables in the drop down list.

[ShivamKS · Accepted solution]

Hi

Instead of the calculated item,try to use aggregated measure for creating the if ..then statement to select the measure. There you will have option to select the aggregated measure as well as the measures you have selected before.