Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Getting the same results in every row while calculating TotalYTD

I am getting the same results in every row while calculating the TotalYTD in powerBI. I have a fact table and dimensional date table. My DAX formula is very simple as TotalYTD(sum(FactTable(sales), D...
Need Help
  • VahidDM's avatar
    VahidDM
    5 years ago

    Hi Anonymous 

     

    Try this measure:

    Measure YTD = 
CALCULATE (
    SUM ( Actuals[Actual] ),
    FILTER (
        ALL ( DateTable ),
        DateTable[DayOfWeek] <= MAX ( DateTable[DayOfWeek] )
    )
)

     

    Output:

     

    Link to download updated file: https://gofile.io/d/ClzBtt

     

    Did I answer your question? Mark my post as a solution!

    Appreciate your Kudos  !!

Radhika2605's avatar
Radhika2605
Icon for Helper II rankHelper II
5 years ago

Anonymous Can you please share screenshot of your model?

 

It appears that your model is not set up correctly which could be causing issues. 

1. Check if there is an "Active" relationship between the tables.

2. Also, this thing might not make much difference but could you please go into your data model and right click on the dat table and click on. - mark as date table and choose the date column. Sometimes when date table is not marked as a date table then there are some issues in time intelligence functions. 

3. Please share a screenshot of date table as well as the other table so that the fields in it are visible to understand better.

4. Please share a screenshot of your model.

 

Thanks

Radhika

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    It is the data model i am using. it gives me the same result in every field. 

    i am trying to use the following DAX function and getting the same results in every field

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      Hi,

      Remove the DateTable[DayofWeek]=2 input from your measure.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks Ashish_Mathur  for being here again. i removed that filter but now it is giving me the yTD results in every field. i wonder why is that giving me same value in every field. also i am learing and trying to get the YTD sale for all 2nd day of week which gives me a specific value agianst every record as i have shared in image.