Help with ALLSELECTED by specific column summarized

[nj-matt]

I think there is a solve somewhere I am not thinking, but here is what I am trying to accomplish using the ALLSELECTED dax to summarize total sales -->

Customer	Product	Sales	Total Sales
Drug Store	Candy Bars	100	400
Grocery Store	Candy Bars	100	400
Mass Merch	Gum	100	400
C-Store	Cookies	100	400

Here is what I want, alway summarized dynamically by product -->

Customer	Product	Sales	Total Sales
Drug Store	Candy Bars	100	200
Grocery Store	Candy Bars	100	200
Mass Merch	Gum	100	100
C-Store	Cookies	100	100

I need it to be dynamic since other filters will routinely by applied (year, class of trade) but for that total sales column I need always at the parent product level. Is it possible withinnthe dax formula or do I need a new table?

[MohammadLoran25 · Accepted solution]

Hi @nj-matt ,

Try this:

Measuree =
CALCULATE (
    SUM ( CustomerProductSales[Sales] ),
    FILTER (
        ALLSELECTED ( CustomerProductSales ),
        CustomerProductSales[Product] = SELECTEDVALUE ( CustomerProductSales[Product] )
    )
)

It helped? Mark it as an accepted solution.

Regards,

Loran

[nj-matt]

Success! Thanks so much, I knew it had to be something simple