Slice with two or more filter

[Yogi_Hayate]

Hi, I have some issues with slice since i want to make multiple filter for my delivery dashboard.

In my dashboard contains of [Table of Order], [Filter], [Order Detail].
In my filter table, there are multiple row, 

First row - filter my table of order based on value of [City]  
Second row - filter my table of order based on value of [Finished manufactured item]

I like my user could view multiple order which have finished in this same City. 

I have try write this on slice but turns out it didn't work out.

How to make this work? 

[Aurelien]

Hi @Yogi_Hayate 

Which expression did you try in the row filter condition of your slice ?

Did you try using AND() too ?

[Yogi_Hayate]

I haven't try using And

But i tried with
OR( fltr_Tbl_Ordr[Filter Kota]=[Kota], 
         fltr_Tbl_Ordr[Filter Status Atasan]=[Status Atasan]
         fltr_Tbl_Ordr[Filter Status Bawahan]=[Status Bawahan])                   

Both [Status Atasan] and [Status Bawahan] are virtual column, [Kota] is ref text.

And turns out its was blank

[Aurelien · Accepted solution]

What about:

OR( 
  ANY(fltr_Tbl_Ordr[Filter Kota])=[Kota], 
  ANY(fltr_Tbl_Ordr[Filter Status Atasan])=[Status Atasan]
  ANY(fltr_Tbl_Ordr[Filter Status Bawahan])=[Status Bawahan]
)       

[Yogi_Hayate]

There is a error shown like this

Cannot compare Ref with List in (ANY(Fltr_Tbl_Ordr[Filter Kota]) = [Kota])

[Aurelien]

You have to adapt this expression according to the type you use.

If [Kota] is a list, then you will need to change the expression into:

OR( 
  IN(ANY(fltr_Tbl_Ordr[Filter Kota]),[Kota]), 
  ANY(fltr_Tbl_Ordr[Filter Status Atasan])=[Status Atasan]
  ANY(fltr_Tbl_Ordr[Filter Status Bawahan])=[Status Bawahan]
)       

[Yogi_Hayate]

Ahhh, I  manage to resolve this with this code

OR( 
  (fltr_Tbl_Ordr[Filter Kota])=[Kota], 
  ANY(fltr_Tbl_Ordr[Filter Status Atasan])=[Status Atasan]
  ANY(fltr_Tbl_Ordr[Filter Status Bawahan])=[Status Bawahan]
)     

. Thank you, So much appreciate it for your support @Aurelien !