Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get Daily sum

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
PaulDBrown
Community Champion
4 years ago

Can you provide sample data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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