Filter on a measure

[ts3st1000]

Hi, I am showing a table on a measure, and I was wondering if there is an easy way to add a filter on it please. On the table below, I have country defined as a measure ( it does not work as a dimension), but i would like to filter on it.

country	sales
Japan	10
Vietnam	11
Malaysia	12
China	13

Thanks for the help.

[felipedl]

Hi,

Do you mean you want to filter your expression for some specific contry?

If so, you can use set analysis and as an example, if you want the sales for Japan only, you could do:

sum({<country={"Japan"}>}sales)

Felipe.

[OmarBenSalem]

or u can create a new filter/dimension in ur presentation as a master dimension, as follow:

if(country='Japan',country,null())

name it as u want; and drag it a new filter