Filter based on enum list answers

[Tommyfish29]

HI,

I have made a dashboard filter and chart that changes based on enum choices,

It works erfect.

CASH table has data (  [GAME] is an enum choice  This is a slice

CASH_DASHBOARDFILTER is the edit choices ( [CASH_GAME] ) if matches [GAME] dislays records with the game match  CASH_DASHBOARDFILTER table has one row and the choices that change with an edit in place for each column this is formula i use that works great

CASH SLICE ROW FILTER FORMULA

if(IsNotBlank(Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)),
[GAME] = Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)

I have 2 columns that are " enumlist "

The above formula does not work for enumlist and i vamt make one that does

Both Tables have the same looking data (  choice1, choice2 ) 
I get cannot compare list with ref error or other errors no matter what i try?

Any ideas?

[Suvrutt_Gurjar]

---

@Tommyfish29 wrote:

I have 2 columns that are " enumlist

---

Please mention where are these enumlist columns. In the CASH table or CASH_DASHBOARDFILTER table or one each in both the tables. This will help to suggest an expression.

[Tommyfish29]

HEy,

Thanks for reply

The enum list is a 3rd table that Both the CASH and DASHBOARD tables get the list.  The list is user changeable and the list on its own table seemed the best idea

SO both [CASH_GAME] and [GAME] are enumlist base type ref to the list table

[Tommyfish29]

On the dshboard filter there are 3 buttons for the three choices on the enumlist.

if someone chooses say choice 1 and choice 3

i want the rows in the cash rable that column GAME enumlist choices were choice 1 and choice 3  exactly,  noy in one choice is in it, but exctly only 1 and 3 returned

[Suvrutt_Gurjar]

Thank you. Please try

IF(ISNOTBLANK(Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)),
ISNOTBLANK( INTERSECT( [GAME] ,  SPLIT(TEXT(Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)),",")))

[Tommyfish29]

Hey,

Thanks for the help

There is one of these missing   )

No matter where i try put it i get different error,

intersect takes 2 params

if function not use correctly

i also tried variatons without the second isnotblank,  cant get it

Where doesthe missing "0" go

IN the old row filter try,

i had all enum only not enumlistm

and 

AND(if(IsNotBlank(Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)),
[GAME] = Index(CASH_DASHBOARDFILTER[CASH_GAME], 1),
true),if(IsNotBlank(Index(CASH_DASHBOARDFILTER[CASH_LOCATION], 1)),
[LOCATION] = Index(CASH_DASHBOARDFILTER[CASH_LOCATION], 1),
true))

In your formula fr the list, i kind of understand, but thought if we are matching exact values, there should be an = sign like [GAME] =

And i find the second isnotblank confusing, but am confused lol so

[Suvrutt_Gurjar]

Please try below. Presume you are using it as a slice filter expression.

IF( ISNOTBLANK(Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)),
     ISNOTBLANK( INTERSECT( [GAME] ,               SPLIT(TEXT(Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)),",")

                               ),

     FALSE

            )

[Tommyfish29]

Thanks, but in the new formula there are 8 x (   and 7 x )

was unable to be parsed: Number of opened and closed parentheses does not match.

[Suvrutt_Gurjar]

Sorry , please try

IF( ISNOTBLANK(Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)),
     ISNOTBLANK( INTERSECT( [GAME] ,               SPLIT(TEXT(Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)),",")

                               )),

     FALSE

            )

[Tommyfish29]

Hey Sir,

That worked, however it cancels out the other filters and nothing shows unless something from the list is selected ( the 2nd isnotblank ) i was told the idea of that AND . IF  filter is that they are all always true even if blank.
when was just 6 enums, all with the AND( IF(  if nothing was selected from one of them the data still comes up from other selections. and if all 6 were blank, it showed every row in the table, so i games is blank and locations is selested ,  it will show all game types chosen rowa at that location

also the results are not just exact match, if value 1 only is selected, it show records that contain value one, not just records that the user had put only valus 1 it shows 1&2, 1&3,  just not 2&3.  

[Suvrutt_Gurjar]

Please try for exact match and other requirements you mentioned:

IFS( ISNOTBLANK(Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)),
 [GAME] =SPLIT(TEXT(Index(CASH_DASHBOARDFILTER[CASH_GAME], 1)),",")

                  )