Forum Discussion
Solved
Help with ALLSELECTED by specific column summarized
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 ...
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
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
Success! Thanks so much, I knew it had to be something simple
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])RETURNSUMMARIZE('Table2 (2)','Table2 (2)'[Company ],'Table2 (2)'[MonthName],"TotalQty", CALCULATE(SUM('Table2 (2)'[QTY]),FILTER('Table2 (2)','Table2 (2)'[Sent] IN currentwn)))
