I have a Dashboard with Filters which works fine but I can only select one item from each Filter.
I cannot figure out how to allow multiple items to be selected.
E.g, I wish to select multiple Status
AND(
IF(ISBLANK(ANY(Filters[Filter Client])),TRUE,ANY(Filters[Filter Client])=[Client Name]),
IF(ISBLANK(ANY(Filters[Filter Site])),TRUE,ANY(Filters[Filter Site])=[Site]),
IF(ISBLANK(ANY(Filters[Filter Status])),TRUE,ANY(Filters[Filter Status])=[Status]),
IF(ISBLANK(ANY(Filters[Filter Created Start Date])),TRUE,ANY(Filters[Filter Created Start Date])<=[Date Created]),
IF(ISBLANK(ANY(Filters[Filter Created End Date])),TRUE,ANY(Filters[Filter Created End Date])>=[Date Created])
)
I tried using Enum - Ref but that didnโt work. Iโm guessing its the use of โAnyโ in the expression?
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |