Variable qualification cannot be changed
I am getting an error ("Variable qualification cannot be changed") when trying to change the qualification of a variable to dimension or detail. The formula for the variable is as follows.
Variable = If(Sum((Measure 1) + (Measure 2) )>0 )Then "Text 1" Else "Text 2"
I am trying to use the variable as a drill filter. When I use it as a column in the report, then it displays correct output.
Could anyone please help resolve the issue? Thanks.