I am trying to exclude a value in a dimension and have tried below three methods and keep getting "Invalid dimension" message.
IF(NOT MATCH ([Reason], 'NO'), [Reason]}
IF([Reason] <> 'NO', [Reason]}
Did I do something wrong?
Thanks in advance!
if([Reason] <> 'Fieldvalue', [Reason])
or you can try below aswell
if([Reason] <> 'Fieldvalue', [Reason],null())
Thanks Chanty for trying to help. I tried both and still not working...
My bad! I just discovered that I used the curly bracket to end instead of the round bracket! That's the whole reason why it wasn't working! Thanks Chanty for your patience....
Retrieving data ...