How to filter range of measure value for specific dimension


I need to ignore some specific range of measure data for some specific dimension value. Please help.


Eg :



Yellow lines to be ignored.

when product name = computer or laptop then amount is not equal to between 100 to -100


Please advice.




Best Answers

  • Valiant
    Valiant 🔵
    Answer ✓

    If you're wanting to remove rows where the product is computer or laptop and the value is between that range you could do something like this:


    CASE WHEN `Product Name`  IN ('Computer','Laptop) AND `Amount` >= -100 AND `Amount` <= 100 THEN 1 ELSE 0 END

    If you use that beastmode as your filter value and set it = to 0 then you would only be looking at "non-yellow" rows.


    Let me know if this isn't what you were trying to accomplish.





    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

  • Thank you for the prompt response. This worked. ?