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)
)
So an OR instead of AND?
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
)
)
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)
)
User | Count |
---|---|
43 | |
29 | |
29 | |
14 | |
14 |