How to filter range of measure value for specific dimension

user01073

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

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

Thank you for the prompt response. This worked. ?

BlueRooster

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

Thank you for the prompt response. This worked. ?