How to filter range of measure value for specific dimension

user01073 · February 2018

Hello,

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.

Thanks

Bikash

BlueRooster · February 2018

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.

Sincerely,

ValiantSpur

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

user01073 · February 2018

Thank you for the prompt response. This worked. ?

BlueRooster · February 2018