Forum Discussion

ilcaa72's avatar
ilcaa72
Helper 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 way to accomplish this

 

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

 

 

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Perhaps:

     

    threshold = IF(test[diff]>=-5 && test[diff]<= -.50,test[diff],BLANK())
    • ilcaa72's avatar
      ilcaa72
      Helper 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
        Microsoft Employee
        7 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