Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I created an measure by excluding some values and now i dont want to see that excluded values in the search icon in the straight table.
My table is like below
Department | Code | Amount |
Sale | AB | 200 |
Sale | BA | 100 |
Finance | XY | 300 |
Finance | YX | 400 |
I created below measure to show rows only with Code=AB,XY :
if(Code='AB' or Code='XY',Amount)
Now i dont want to show excluded code(BA,YX) in the front end :
Could you please assist me how can i hide the values from front end.
Thanks in advance
Hi, why not to use the same technique you done with amount?: if(Code='AB' or Code='XY', Code)
Additionally you can convert this new Code to Master Item, to prevent show expression when filtering.
Hi @Rsaiq ,
Use this formula in the filter
=Pick(Match (Code , 'AB' , 'XY'), 'AB' , 'XY' )
Regards,
Tanish