Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Help with repeated column sum

The database displays the following:

01.JPG

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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.