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.
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! Go to 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],",")))
User | Count |
---|---|
15 | |
11 | |
7 | |
3 | |
2 |