Forum Discussion

ilcaa72's avatar
ilcaa72
Icon for Helper IV rankHelper IV
8 years ago

Limit calculated Column values for a slicer

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 wa...
Need Help
ilcaa72's avatar
ilcaa72
Icon for Helper IV rankHelper IV
8 years ago

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

 

 

 

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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