Using measures in list or dropdown controls.

[Renato_sas]

Hi @MahRaz,

Yes, but you will need a few additional auxiliary calculations, because you cannot use categories in aggregated measures, like we used before with the calculated item to evaluate the parameter value.

AuxMeasure1:

IF 'selected measure1'p Missing

RETURN 0

ELSE IF 'selected measure1'p = 'Aggreg Measure A'

RETURN 1

ELSE IF 'selected measure1'p = 'Aggreg Measure B'

RETURN 2

ELSE .

NewMeasure1 (this is your new proxy aggregated measure):

IF Min(AuxMeasure1) = 0

RETURN .

ELSE IF Min(AuxMeasure1) = 1

RETURN AggregMeasureA

ELSE Min(AuxMeasure1) = 2

RETURN AggregMeasureB

ELSE .

I've used the funtion Min(), but Max() and Avg() also work.

Best,

Renato

[mvpalheta]

Hi,

you tried click the right button on the variable and change the measure property to category??