Solved: Is there a way to simply add an item to an ANY() l... - Page 2

Mike_T · 02-17-2021 11:37 AM

I’ve got a list of column of “States”. I’m using a detail view as a dashboard filter as described in this video: Dynamic Dashboards

I’m trying to allow the user to select a list of states but also always include the “state” ‘AD’. AD is the acronym for the total division. Essentially the data includes programs that are for AD and specific state programs. When the user selects a state or a couple of states this filter will return programs from AD + the selected states. Here is 1 part of my AND expression in the Slice filter:

IF(ISBLANK(ANY(QRManager Map[State Filter])), TRUE,[State] = ANY(QRManager Map[State Filter])),

How do I add AD to the list of states in the (QRManager Map[State Filter]) column?

Steve

So this:

IF(ISBLANK(ANY(QRManager Map[State Filter])), TRUE,[State] = ANY(QRManager Map[State Filter] + {“AD”})),

is a slice row filter?

And QRManager Map[State Filter] refers to an EnumList column?

If yes to both, try this instead:

OR(
  ISBLANK(QRManager Map[State Filter]),
  IN([State], SPLIT((QRManager Map[State Filter] + {“AD”}), ","))
)

View solution in original post

Is there a way to simply add an item to an ANY() list?