How can I use sumx to add only those of a very specific date

[Syndicate_Admin]

Hello I have a question about the Sumx function, I want you to add me for example only the sales of each date, such as: "12/08/2023"

I appreciate your help

[TomMartens]

Hey,

not sure if I understand your question correctly, but this will do the trick:

measure =
SUMX(
    VALUES('<tablename>'[Date])
    , CALCULATE( SUM( '<tablename>'{Sales])
)

But maybe you are looking for this:

measure =
SUMX(
    VALUES('<tablename>'[Date])
    , CALCULATE( SUM( '<tablename>'{Sales] ) , KEEPFILTERS( '<tablename>'[Date] = '2023-09-25' ) )
)

If none of the above is returning what you are looking for,  please provide a visual showcasing the requirement.

Regards,

Tom