Calculate only when slicers are applied

[chris-d]

I've got a data table with a number of different products and metrics listed, and a card with calculations based on the data table. When no slicers are applied the calculations on the card are astronomical, but the data shouldn't be used as the metrics should never be looked at for the whole table. Is there a way for the card to calculate only when slicers are applied?

[Samarth_18 · Accepted solution]

Hi @chris-d ,

You can add if condition like below:-

Measure = if(isfiltered(table[slicer_column]),{your calculation})

or

Measure = if(selectedvalue(table[slicer_column])<> blank(),{your calculation})

Thanks,

Samarth