invalid dimension

[Anonymous]

is it possible to have this expression in master item dimension? it is giving me "invalid dimension error".

I've tried to put it in the master item - measure and it worked well... But I wanted it to be a dimension so I can have yes and no filter in the visualisation.

[sunny_talwar · Accepted solution]

You would need to use Aggr() function around this to make it work

Aggr(If(Sum([Aggr nOffered]) > 1, 'yes', 'no'), Dimension)

or use it without Sum() if it is already aggregated

If([Aggr nOffered] > 1, 'yes', 'no')

[Anonymous]

Aggr(If(Sum([Aggr nOffered]) > 1, 'yes', 'no'), Dimension) - it worked!!

Thanks genius!