Slicer from measure with multiple selections

[FRC]

Goodafternoon,

I made a measure in power bi that show a certian problem if certian values are shown.

I called it check

Check = IF([A] > 1 , "A123","")&IF([B] > 0 , "B456,"")&IF([C] = 0 , "C789","")&IF([D]<[X], "X>D","")

Than i made a table that shows all possible combinations of this check

Status =

var x1=SUMMARIZE(Artikelgegevens,Artikelgegevens[Samenvoeging],"Check",[Check])

return

SUMMARIZE(x1,[Check])

This Check i put in a slicer.

Then i made a Check filter to put in the visual that if Check_filter is 1 the visual filters

Check_filter =

var x1=SELECTEDVALUE('Status'[Check])

return

IF(ISBLANK(x1),1,IF([Check]=x1,1,0))

This really works well if in the slicer i select one value, if i select multiple in the slicer this doenst work. i there any way to make this work? (select multiple values in the slicer, from a measure and have the the visual react on the selections). 

thank you

[FRC]

Hi,

I have this:

Check_filter =

var x1=SELECTEDVALUE('Status'[Check])

return

IF(ISBLANK(x1),1,IF([Check]=x1,1,0))

and changing it to this 

var x1=Values('Status'[Check])

return

IF(ISBLANK(x1),1,IF([Check] IN x1,1,0))

this Gives the following error: calculation error in measure" artikelgegevens[Check_filter]: A table of Multiple values was supplied where a single value was expected.

[SamWiseOwl · Accepted solution]

Hi @FRC 

IsBlank is for single values, use IsEmpty() for a column or table 🙂

[SamWiseOwl]

Hi @FRC 

If you have multiple items use VALUES() and the IN operator.

var x1=Values('Status'[Check])

IF(ISBLANK(x1),1,IF([Check] IN x1,1,0))