Calculate Total Sales with a filter of a groupe of Sellers

[Sofinobi]

Hi all,

please if you can help me, to filter a liste of Seller

i have a measure of TotalSales
Sales_Table
Sellers_Table, (with all the sellers names and id)
Sellers_Table_Convention ( with only a part of sellers (16) that are in the convention)
now, i need to calculate the TotalSales of those 16 sellers that are in the Sellers_Table_Convention
something like : TotalSales_Convention =
                           Calculate ( TotalSales,
                          Filter( Sellers_Table, Seller_Table[Seller]
                          in Sellers_Table_Convention[Seller])

[v-zhangti · Accepted solution]

Hi, @Sofinobi 

You can try the following methods.

Measure = CALCULATE(SUM(Sales[Sales]),FILTER(ALL(Sales),[Seller] in VALUES(Seller_Convention[Seller_Convention])))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sofinobi]

thats perfect, exactely what i'm looking for, thank you so much my friend 

thanx again 
have a nice day

[Sofinobi]

here is a data sample pbix
the wanted is, the sales of only the seller they are present on "Seller_Convention"
Total Sales