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]))
)
User | Count |
---|---|
26 | |
25 | |
25 | |
23 | |
23 |