Forum Discussion

Robin96's avatar
Robin96
Helper II
3 years ago
Solved

Filter a visual with 2 different values

Hey all!

i am trying to filter out all values where T&M is less then 10 000. and at the same time keep the ARR.
i have sensored the Y-axis values. But is there a way to remove the T&M values < 10 000, and keep all the Total recurring values?
i have tried to remove T&M values that is less then 10 000, but then the recurring values also dissapear. 

 

2 Replies

  • Robin96 , A measure like

     

    if([T&M] <10000 , blank(), [T&M])

     

    Assuming T&M is a measure

    • Robin96's avatar
      Robin96
      Helper II

      Thank you so much for this! it worked!
      i had not heard of the blank() return value before, but it solved my problem! 🙂