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

[gch471218]

i want to filter the summarized table when i filter table2{2} by sliceer i.e. by choosing sent or received in the slicer i want my table to be filtered and updated below is the ocde 

qty_sent_MonthlyAggregation =

VAR currentwn = ALLSELECTED('Table2 (2)'[Sent])

RETURN

SUMMARIZE(

   'Table2 (2)'

   ,

    'Table2 (2)'[Company ],

    'Table2 (2)'[MonthName],

    "TotalQty", CALCULATE(SUM('Table2 (2)'[QTY]),FILTER('Table2 (2)','Table2 (2)'[Sent] IN currentwn)))

[gch471218]

Hi can somebody please help

[gch471218]

I'm sorry for the spelling mistakes

[nj-matt]

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