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.
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')
Aggr(If(Sum([Aggr nOffered]) > 1, 'yes', 'no'), Dimension) - it worked!!
Retrieving data ...