Forum Discussion
Use two different filters in a single mesure
Hello everyone, I have a question regarding the creation of a new measure (which can be named A) by using an other measure (B) that has been already created. The measure B represents the whole m...
Hi MFelix,
Thank you for the quick answer.
Measure B = products which have been sold in one year in France. = They are in a column in my table 2
Filter 1 : we can choose seller 1, seller 2.... = sellers present in a column in my table 1 = I put it in the visu as a filter
Filter 2 : zone 2, zone 2,... = a column too in table 1 too
Measure A = B filtered by the seller I have chosen / B filtered by the zone I have chosen
I can give you an example :
B = 100 000 products sold
Filter 1 = seller 1
Filter 2 = zone 3
A = 2000 (the products sold by the seller) / 10 000 (the products sold into the zone 3)
