Measure to Calculate if Slicer matches record

[Anonymous]

I am trying to create a new measure which will determine if a record matches a value in a slicer table.

If I have three records in table Z used to populate the Slicer with records A,B,C.  

Then I would like to create a measure in table Y to determine if column 1 = a value selected in the slicer.

i.e. If Column1.value = Slicer.Selectedvalue then "y" else "n"

[KHorseman]

Is the slicer table disconnected from the records table? That is, there is no relationship between the two tables? If so this is easy.

Assuming they are disconnected and you are displaying every row from the records table individually, this will wok.

Measure = IF( FIRSTNONBLANK(RecordTable[Column1], 1) = FIRSTNONBLANK(SlicerTable[SlicerColumn], 1), "y", "n")

[Anonymous]

Thanks for the suggestion.

Yes the slicer table is "unrelated" to the record table.

I tried your suggestion and it works if a single record is selected in the slicer table, but when multiple items are selected it only selects the "FirstNonBlank" which may or may not be the correct value to select.

Anyone else with further suggestions?

[KHorseman]

Are you saying you want it to check if each record value equals any of multiple selected values in the slicer?

[Anonymous]

yes that's correct.

[v-huizhn-msft]

Hi @Anonymous,

Please try the CONTAINS function. Please use the formula below and check if it works fine.

result=IF(CONTAINS(SlicerTable, ALLSELECTED(SlicerTable[SlicerColumn]), FIRSTNONBLANK(RecordTable[Column1], 1)),"yes","No")

Best Regards,
Angelia