Forum Discussion

Yoshimitsu411's avatar
Yoshimitsu411
Resolver I
4 years ago

TotalYTD Based on Sum is Showing Incorrect Values

Hi All   I have the following measures:   UseRelationship is commented out because I didn't think it was necessary given the Quantities table is connected to the Date table indirectly via other t...
Need Help
Yoshimitsu411's avatar
Yoshimitsu411
Resolver I
4 years ago

I have made some progress but still cannot work out why YTD for March is not blank when the sum is 0.00??

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Yoshimitsu411 ,

     

    It's hard to reproduce the scenario, can you share some sample data so that we could check the formula?

     

    Best Regards,

    Jay

    • Yoshimitsu411's avatar
      Yoshimitsu411
      Resolver I
      4 years ago

      Hi Anonymous 

       

      In the screenshot below, I want to be create a running total by month without using TotalYTD or DatesYTD. 

      TotalYTD and DatesYTD do no work due to the inactive relationship between my Fact table and Calendar table. So I need another way to sum the current month + previous month totals for each month.

       

      This is my measure for RE column

      RE = 
CALCULATE(
    SUM('Fact Table'[RE]),
      USERELATIONSHIP(
          'Fact Table'[Finish Date],
         'Calendar'[Date]
     )
)

       

       

      The numbers I am hoping to see for RE Month Running Total are 

       

      JAN - 1823.93
      FEB - 3924.38
      MAR - 6854.58
      APR - 9485.38
      MAY - 16197.27
      JUN - 22117.43
      JUL - 29069.76
      AUG - 34472.28
      SEP - 35423.93
      OCT
      NOV
      DEC

       

      Thank you.

       

      Yoshi