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])
    )
Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
10 months ago

Hi nmckeown1 ,

 

Please try approach suggested by Cookistador .

it could be relationship issue or the interaction between visuals are off.

 

Please check and let me know.

 

Thanks and Regards,

Praful