Filtered table based on multiple values from enum list

Hello to everyone,

I created a details view where i can filter values from another table. 

This only works if I select a single value from the enum list column "Sub category".

On the other hand, if you select more than one value from the eunm list column, I don't see anything.

Schermata 2022-07-14 alle 11.05.42.png

Schermata 2022-07-14 alle 11.06.05.png

This is the formula in slice to filter values:

AND(
IF(ISBLANK(ANY(DB[Category])), TRUE,
[Category]=ANY(Cerca_DB[Category])),

IF(ISBLANK(ANY(DB[Sub Category])), TRUE,
[Sub Category]=ANY(Cerca_DB[Sub Category])),

IF(ISBLANK(ANY(DB[BSR])), TRUE,
[BSR]>=SUM(Cerca_DB[BSR min])),

IF(ISBLANK(ANY(DB[BSR])), TRUE,
[BSR]<=SUM(Cerca_DB[BSR max]))

IF(ISBLANK(ANY(DB[Revenue])), TRUE,
[Revenue]>=SUM(Cerca_DB[Revenue min])),

IF(ISBLANK(ANY(DB[Revenue])), TRUE,
[Revenue]<=SUM(Cerca_DB[Revenue max]))

)

how can i see all the values ​​i select in the enum list column?

TKS

 

 

 

 

Solved Solved
0 3 299
1 ACCEPTED SOLUTION

Maybe instead of

IF(ISBLANK(ANY(DB[Sub Category])), TRUE,
[Sub Category]=ANY(Cerca_DB[Sub Category]))

you could try this

IF(ISBLANK(ANY(DB[Sub Category])), TRUE,
IN([Sub Category], SPLIT(Cerca_DB[Sub Category],","))
)

View solution in original post

3 REPLIES 3
Top Labels in this Space