SUMX and GROUPBY

[marami21]

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,

[v-alq-msft · Accepted solution]

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.

[Pragati11]

Hi @marami21 ,

Can you please share some sample data and what you are trying to achieve?

Thanks,

Pragati