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
... View more
