Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate Totals Are Incorrect

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 un...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

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