grouping total sum by day

[Anonymous]

Hi, I'm trying to aggregate the data by column production date. That is i want to sum all the values for each day into one column to find out the overall Yield for that day:

So the first two values of the column total should be (1680+2000 = 3680) and Ythe first two values of Total produced should be (1714+2036 =3750). The same applies to the rest of the days

 I need help on the how to calculate these columns. Currently my Total is a measure Total = sum(total good quantity) and Total Produced = sum(total produced)

After this I will be able to calculate my Yield correctly

Thanks in advanced

[v-lili6-msft · Accepted solution]

HI, @Anonymous

    I have tested on my side, 

Assume that this sample data

then add two measures

Total = sum(Table1[total good quantity])

Total Produce = SUM(Table1[total produced])

then drag them into visual

it works well, so I guess that you may drag other fields into the visual and leads to they don't aggregate.

like this

if I drag Name field into the visual

Please check the fields in the table visual that whether it needs to be aggregated.

Please share your pbix or some screenshot for us. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin