Forum Discussion
nmckeown1
Helper II
Helper IIDaily 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: ...
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]))
nmckeown1Helper II
Helper IISolved:
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])
)