Get Daily sum

[Anonymous]

I have a table with date and sales but when I applied summation to get daily sum it gives wrong results. I used:

Daily Sales = SUM(sales[Sales])

My original table (sales):

After using the formula, I get summation as below (which is wrong):

Please help!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could create a measure like below.

measure = calculate(sum(sales[sales]),filter(allselected('sales'),'sales'[date]=selectedvalue('date'[date])))

Best Regards,

Jay

[PaulDBrown]

Can you provide sample data?

[Anonymous]

I am not sure how but, re-doing the model gave the correct solution. Thanks all

[Samarth_18]

Hi @Anonymous ,

Are you using date and sales from same table or different?

Thanks,

Samarth

[Anonymous]

HI! From different tables. Date from calander table and sales from sales table. I joined them based on the date.

[Anonymous]

I summarized using 'sum' in the table view insdead  of calculated measure, and still getting the same results, which is wrong. Thanks!

[PaulDBrown]

Are both the date fields in the Calendar table and sales table set to type date (not date/time)?

Is the relationship between the Calendar table and the sales table set to single direction and One-To-Many?

[Anonymous]

Yes and yes. Still wrong results. Thanks!

[Anonymous]

@amitchandak @johnt75