Forum Discussion
SUMX and GROUPBY
Hello
I have a table that groups the sales amount by date and category. That way I can use the date and category to filter the sales amount
I want to save space deleting that table and use only one dax to get the final sales amount. Something like SUMX(GROUPBY(...)). The problem is that I can't use filters when I use that dax
Is there a way to create that dax and use filters?
Thank you,
Hi, marami21
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may try to create a measure like below.
Result = SUMX( SUMMARIZE( 'Table', 'Table'[Category], 'Table'[Date], "Sales", SUM('Table'[Sales]) ), [Sales] )Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
v-alq-msftCommunity Support
Hi, marami21
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may try to create a measure like below.
Result = SUMX( SUMMARIZE( 'Table', 'Table'[Category], 'Table'[Date], "Sales", SUM('Table'[Sales]) ), [Sales] )Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
