Forum Discussion

nmckeown1's avatar
nmckeown1
Icon for Helper II rankHelper II
10 months ago
Solved

Daily Average won't update using a year slicer

I am using an average calculation for the number of chats per day answered through WhatsApp. I created a summary table that has a total in the WhatsApp column for each date of the year:     ...
Need Help
  • nmckeown1's avatar
    nmckeown1
    10 months ago

    Solved:

    I used my already existing aggregated table, instead of the summary table in the calculation - and this worked with the year filters.

     

     

    Daily_average_whatsapp =
    CALCULATE(
    AVERAGEX( VALUES('int dim_dates'[short_date]), [Target WhatsApp]),
    ALL('int dim_dates'[short_date])
    )
Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
10 months ago

I suspect the issue lies with the relationship between Calendar_year and your calculated table.

When a visual returns the same value repeatedly, it often indicates a missing or inactive relationship between the fields being used.

Could you confirm if there is a relationship between your two tables? Establishing the correct relationship should allow you to see the intended values.