Multie Select on Filtered Dashboard

[Martina (Martina Hawkins)]

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?

[Steve (Steve Coile)]

@Martina

I wish to select multiple Status

Use a column type of EnumList with a base type of Ref.

@Martina

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])
)

Could also be expressed:

AND(
  OR(
    ISBLANK(Filters[Filter Client]),
    IN([Client Name], Filters[Filter Client])
  ),
  OR(
    ISBLANK(Filters[Filter Site]),
    IN([Site], Filters[Filter Site])
  ),
  OR(
    ISBLANK(Filters[Filter Status]),
    IN([Status], Filters[Filter Status])
  ),
  OR(
    ISBLANK(Filters[Filter Created Start Date]),
    (MIN(Filters[Filter Created Start Date]) <= [Date Created])
  ),
  OR(
    ISBLANK(Filters[Filter Created End Date]),
    (MAX(Filters[Filter Created End Date]) >= [Date Created])
  )
)

[Martina (Martina Hawkins)]

Hi @Steve, using Enum- Ref was the first thing I tried but it gave me a blank list

[Steve (Steve Coile)]

Yeah. I feel like the behavior of Enum(List) of Ref has changed. You’ll need to use Valid If or Suggested values to generate a list of values from which the use can choose.

[Martina (Martina Hawkins)]

Thanks so much @Steve . Got it working now with a ValidIf and thanks for above expression