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:

 

 

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?

 
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])
    )

4 Replies

  • 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.

  • nmckeown1's avatar
    nmckeown1
    Icon for Helper II rankHelper II
    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

  • 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.