Metric Filters

I have to create a filter that toggles between sales >0 and Sales =0. I’ve created a parameter but when i select the rest of the columns becomes 0. How can this be achieved.


Hello @AnjanaShanmugam - Thank you for posting your query. Can you create a calculated field with the below logic assuming that there are no negative sales.

ifelse({Sales} = 0, ‘Sales = 0’, ‘Sales > 0’)

Once you create that you can use this field to link it with the parameter and use the same to establish a Filter Action to interact with the visual and filter it according to the selected criteria. Hope this helps!

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!


Thanks for this solution @sagmukhe! :slight_smile:

hi @AnjanaShanmugam, Did @sagmukhe solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

1 Like

An alternative solution would be to create this calculated field, and then place a filter on it and set equal to 1.

ifelse({sales}=0 and ${parameter}=‘Sales=0’, 1, {sales}>0 and ${parameter}=‘Sales>0’, 1, 0)

1 Like