How only select certain sites to show on a card

[amalrio]

Hi Gurus, 

I have a measure that need to say no data when only certain site ids are selected.

this measure gives me an error. 

Message = IF (

ISFILTERED ( 'DIM-Sites'[SITE_ID] IN {"BR2", "TP1"} ),

"",

"No Data"

)

My requirement is to show No data in a measure when those two sites are selected, My DIM-Sites tabel has 5 other site ids,

can you please help me.

Regards

Amal Eranda

[amitchandak · Accepted solution]

@amalrio , Try like

Message = IF (
countx (filter(allselected('DIM-Sites'), 'DIM-Sites'[SITE_ID] IN {"BR2", "TP1"}), 'DIM-Sites'[SITE_ID] ) >0,
"",
"No Data"
)