Dashbord filtering + some values

[TobiasN]

Hi!
Trying to change how the filter works on my dashbord.
I wanna use the [Program] filter as it is. Select multiple programs and it gives me a long list of tools connected to those programs.
But I wanna be able to add some tools thru the [Grupp- nummer] filter. Its a Enumlist column.
Even if those tools aint in the programs selected from [program].
At this point it only shows me the selected [Grupp- nummer] tools thats also IS used in the [program] list. And only those.

What function could help me do this?

AND(
IF(
   ISNOTBLANK(Dashbord filter[Grupp- nummer]),
   IN([Grupp- nummer], Dashbord filter[Grupp- nummer]),TRUE),
IF(
   ISNOTBLANK(Dashbord filter[Artnr]),
   CONTAINS([VC_artikelnrverktyg], Dashbord filter[Artnr]), TRUE),
IF(
   ISNOTBLANK(Dashbord filter[Program]),
   ISNOTBLANK(INTERSECT(SPLIT(TEXT(Dashbord filter[Program])," , "), [Dumpis])), TRUE)
)

[Marc_Dillon]

So an OR instead of AND?

https://help.appsheet.com/en/articles/2357288-or

[TobiasN]

I tried that before and it kinda works.
If I select something in one or two input boxes, nothing happens. The whole list is still showing.
But if I put something in all three boxes it filters out correctly.

Now im just gonna try to find out how to make it work like I want it to. 😄
Im gonne try to find some time to play with this later on.
Thanks

OR(
 IF(
    ISNOTBLANK(Dashbord filter[Program]),
    ISNOTBLANK(INTERSECT(SPLIT(TEXT(Dashbord filter[program])," , "), [Dumpis])), TRUE
   ),
 IF(
    ISNOTBLANK(Dashbord filter[Artnr]),
    CONTAINS([VC_artikelnrverktyg], Dashbord filter[Artnr]), TRUE
   ),
 IF(
    ISNOTBLANK(Dashbord filter[Grupp- nummer]),
    IN([Grupp- nummer], Dashbord filter[Grupp- nummer]), TRUE
   )
)

[TobiasN]

Got it to work as I wanted. 😃
Thanks for the guidance in the right direction.
Its probably not the most beautiful solution. But it works.

OR(
 IFS(
    ISNOTBLANK(Dashbord filter[Artnr]),
    CONTAINS([VC_artikelnrverktyg], Dashbord filter[Artnr])),
 IFS(
    ISNOTBLANK(Dashbord filter[Program]),
    ISNOTBLANK(INTERSECT(SPLIT(TEXT(Dashbord filter[Program])," , "), [Dumpis]))),
 IFS(
    ISNOTBLANK(Dashbord filter[Artnr]),
    CONTAINS([VC_artikelnrverktyg], Dashbord filter[Artnr])),
 IFS(
    ISNOTBLANK(Dashbord filter[Grupp- nummer]),
    IN([Grupp- nummer], Dashbord filter[Grupp- nummer])),
 
IFS(
 AND(
    ISBLANK(Dashbord filter[Grupp- nummer]), 
    ISBLANK(Dashbord filter[Program]), 
    ISBLANK(Dashbord filter[Artnr])), TRUE)
)