please help me with this expression

[luvy]

please help me with this expression

AND(
if(any(select(filter[COLLABORATORS],true))="",
isnotblank([COLLABORATORS]),
[COLLABORATORS]=any(select(filter[COLLABORATORS],true))),

if(any(select(filter[MONTH],true))="",
isnotblank([MONTH]),
[MONTH]=any(select(filter[MONTH],true))),

if(any(select(filter[CATEGORY],true))="",
isnotblank([CATEGORY]),
[CATEGORY]=any(select(filter[CATEGORY],true)))),

[TeeSee1]

It would help if you could explain what you need help with a little bit more.

Given this expression without any context, it looks almost meaningless.

[luvy]

I use an enum list for the Filter table but when I select more than 1 no data is displayed

[TeeSee1 · Accepted solution]

Maybe you could try below

AND(

  IF( ISBLANK(filter[COLLABORATORS]), TRUE,  IN([COLLABORATORS], filter[COLLABORATORS])),

  IF( ISBLANK(filter[MONTH]), TRUE,  IN([MONTH], filter[MONTH])),

  etc,,,

)

I have attached a few screen shots from an app snipped I created. 

My implementation maybe different from yours.

The way I did was to create a slice from the main table and set a filter condition similar to above.

Hope this helps a bit!