Forum Discussion
Use two different filters in a single mesure
Hi MFelix,
Thank you for your answers,
Let's see how it works with a concret example :
Here is the Measure B which is created thanks to a function. The result is 100 000 products sold in a year in a whole country.
As you can see, I also have two filters which determine a zone and a seller. Several sellers belong to a single zone.
If I'm selecting a zone, I have the number of products which have been sold in it.
Here we can see 5000 products for the 5.
If I'm selecting a seller (represented by a number ex : 1401 = Georges) , I have the number of products which have been sold by him.
Here we can see 600 products for the seller 81.
Now I would like to divide in a new measure (A) the result of the third screen by the result of the second. => the number of product sold by a seller compared to his zone.
But the measure A must works with the other zones and sellers.
It is more clear?
Thank you for your time,
Regards,
Rem