Help with repeated column sum

[Syndicate_Admin]

The database displays the following:

This is from a single order to the 8411. When I want to know how much I sold on 05/01/2022 Power BI adds all the rows giving a total of $ 9,595.00 When in reality the sales were only $ 1,919.00

Is there a way to prevent me from joining the repeated rows?

I can't just choose repeated rows because the data changes in the FLINEA, PRODUCT columns. that will serve me to perform another analysis.

[Anonymous]

Hi,
First check ur data relationship, if it is ok then use SUMMARIZE() function by describing which column u should be used for group by statement.