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])
    )
v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
10 months ago

Hi nmckeown1, 

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to Praful_Potphode, Cookistador,  for those inputs on this thread.

Has your issue been resolved? If the response provided by the community member Praful_Potphode, Cookistador, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.