print 0 on filters(column names) selected in slicer

[sonya7]

hello,

when I click on the filters(column name) in the slicer, I want 0 to be written on my card. how can I do that?

[lukiz84 · Accepted solution]

YourMeasure = IF(ISFILTERED(yourColumn), 0, anythingElse)

BR

[sonya7]

thank you so much

[amitchandak]

@sonya7 , You need the slicer to be on an independent table, and then you measure like.

Assume item is selected in slicer and displayed in table

if(Max(Table[Item]) in selectedvalue(Item[Item]), 0, 1)