Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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!!
Thanks genius!