Calculate Totals Are Incorrect

[Anonymous]

I'm using the following DAX to get the 'Quantity_On_Request' for the same day last year.  When I view the data in a table, the totals are correct by day, however the total is incorrect.  

I don't undertand why the 'total' is incorrect, but but the daily numbers are.  

PrevYear Demand Qty = CALCULATE(SUM(Billed_Order_Details[Quantity_On_Request]),DATEADD('Order Date'[Date],-1,year))

[Anonymous]

Hi 

I will create a calculated measure using the following:

CALCULATE(SUM(Billed_Order_Details[Quantity_On_Request]), SAMEPERIODLASTYEAR('Order Date'[Date]))

Hope this help

Tomas

[Anonymous]

Hi Tomas

Thanks for the reply, but using 'SamePeriodLastYear' gives me the same results.  See below, this is what shows on the 'Totals' line of the Table visual.  The daily totals are correct, but it's the 'Total' thats now summing correctly.

Date               PrevYear Demand Qty
11/12/2019    54,959
11/13/2019    48,124
Total               741,722

[Anonymous]

Sorry, I mistyped, it's the 'Total' line that's summing incorrectly.