Daily Average won't update using a year slicer

[nmckeown1]

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:

I used this DAX for a daily average of the WhatsApp column: 

Daily Average_Whatsapp =

AVERAGEX(StandardDevTable_Daily, StandardDevTable_Daily[WhatsApp])  

This works ok, however it is static for each year:

How do I edit the measure so it changes with whatever year is selected in the year filter?

[v-kpoloju-msft]

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.

[Praful_Potphode]

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

[nmckeown1 · Accepted solution]

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]

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.