It should be fairly simple. I am trying to create a slice where it shows all if a list is blank or filters if the list is not blank - but it seems to show no results when the list [Profiles_fk].[Type] is blank. It works when the list is not blank. Thank you
OR(
ISBLANK(User Slice One Row[Profile]),
IN([Profiles_fk].[Type],(User Slice One Row[Profile]))
)
What is the table you are trying to filter and what is the one you use to make the filters? I assume that the right expression would be like this:
OR(
ISBLANK(User Slice One Row[Profile]),
[Profiles_fk].[Type] = ANY(User Slice One Row[Profile]))
)
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |