Limit calculated Column values for a slicer

[ilcaa72]

hello, i have a calculated column that i want to use as a slicer, but i only want a range of the values...

i create this formula but receive error... if someone could help with formula or best way to accomplish this

threshold = CALCULATE(sum(test[diff]), test[diff] >=-5,test[diff]<= -.50)

threshold = FILTER(test, test[diff]>= -5. && test[diff] <= -.50)

[Greg_Deckler]

Perhaps:

threshold = IF(test[diff]>=-5 && test[diff]<= -.50,test[diff],BLANK())

[ilcaa72]

thanks, any idea why my calculated column does not appear as an option??

[v-cherch-msft]

Hi @ilcaa72

You may try to use below measure:

threshold =
IF (
    MAX ( test[diff] ) >= -5
        && MAX ( test[diff] ) <= -.50,
    MAX ( test[diff] ),
    BLANK ()
)

Regards,

Cherie