Help in removing values while searching on table

[Rsaiq]

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

[justISO]

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.

[Tanish]

Hi @Rsaiq ,

Use this formula in the filter

=Pick(Match (Code , 'AB' , 'XY'), 'AB' , 'XY' )

Regards,

Tanish