Use two different filters in a single mesure

Question

Hello everyone,&nbsp;I have a question regarding the creation of a new measure (which can be&nbsp;named A)&nbsp;by using an other measure (B)&nbsp;that has been&nbsp;already&nbsp;&nbsp;created. The measure B represents the whole marketshare of a product.I also have two filters, one for the sellers and another for their zones. Each zone represents an area where the product is sold and&nbsp;it is made of&nbsp;several sellers.&nbsp;A = B(filter&nbsp;seller chosen by the user)&nbsp;/ B(filter zone of the seller chosen by the user)&nbsp;or&nbsp;A = the marketshare of the seller compared to his zone.&nbsp;The request containing the market share data is different from the one containing the columns used for the filter. They are linked.&nbsp;Do you know how it can be fixed ?&nbsp;Thank you,&nbsp;

mfelix · Answer

Hi&nbsp;Rem,&nbsp;You information is very absctract however you have to make the measures to&nbsp; calculate over your filters something like this:&nbsp;A =
VAR Selected_Seller =
    MAX ( Table[Seller] )
VAR Selected_Zone =
    MAX ( Table[Zone] )
RETURN
    DIVIDE (
        CALCULATE ( SUM ( Table[Column] ); Table[Seller] = Selected_Seller );
        CALCULATE ( SUM ( Table[Column] ); Table[Zone] = Selected_Zone )
    )Where I have SUM(Table[Column]) you can use your measure.&nbsp;Not sure if this helps in anything but without data and expected result is hard to give you a more exact response.&nbsp;Regards,MFelix

rem · Answer

Hi MFelix,&nbsp;Thank you for the quick answer.&nbsp;Measure B =&nbsp; products which have been sold in one year in France. = They are in a column in my table 2Filter 1 : we can choose seller 1, seller 2.... = sellers present&nbsp;in a&nbsp;column in my table 1 = I put it in the visu as a filterFilter 2 : zone 2, zone 2,... = a column too in table 1 tooMeasure A = B filtered by the seller I have chosen / B filtered by the&nbsp;zone I have chosen&nbsp;I can give you an example :&nbsp;B = 100 000 products soldFilter 1 = seller 1Filter 2 = zone 3&nbsp;A = 2000 (the products sold by the seller) / 10 000 (the products sold into the zone 3)

mfelix · Answer

Hi&nbsp;Rem,&nbsp;The formula is similar to what I used in the previous post except where you have sum you should use the B measure.&nbsp;Sorry for insisting on this but your information is too generic to help you better.&nbsp;Regards,MFelix

rem · Answer

Hi MFelix,&nbsp;Thank you for your answers,&nbsp;Let's see how it works with a concret example :&nbsp;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.&nbsp;&nbsp;&nbsp;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.&nbsp;&nbsp;&nbsp;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&nbsp;600 products for the seller 81.&nbsp;Now I would like to divide in a new measure (A) the result of the&nbsp;third screen by the result of the second. =&gt; 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?&nbsp;Thank you for your time,Regards,Rem&nbsp;

rem · Answer

Hi MFelix,&nbsp;Do you better understand with these new informations?&nbsp;Best Regards,&nbsp;

Forum Discussion

Use two different filters in a single mesure

6 Replies

Related content

Page Level filter for different groups

Single Slicer to Filter Multiple Columns

Different schema into different destination

Filtering Different Data Sets with a Single Slicer

Enable single selection in filter