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 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))

3 Replies

  • 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.