Filter Measure Results

I have the measure

DIVIDE([Total Sales LM] , [Sum Total Sales] ) -1

which returns, amongst others values, a -100. I would like to filter out the -100 out of the result set. I am using a Matrix that has as row values country names, values as total sales and on my column header, the measure above.

Thank you for your help.


There are number of different ways to do this, but I think the simplest and most direct is to click on the matrix visual, and then set the filter pane on that visual to show items when the value of your measure is not equal to -100.


Hope this is helpful.

  • Brian

Hi @josevaras, we’ve noticed that no response has been received from you since February 01, 2020. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!