Summarize average monthly table

Hi nmckeown1 ,

Thanks for reaching out to the Microsoft fabric community forum. Also thank you Praful_Potphode  for your response.

The issue occurs because the table you created with SUMMARIZE is a calculated table, which is static and doesn’t respond to slicers. That’s why the Campaign filter isn’t affecting your results.

To make the monthly average dynamic and reflect slicer selections, please use the following measure instead:

Overall Monthly Average =
VAR MonthlyTotals =
    SUMMARIZE(
        'call_table',
        'int dim_dates'[year_month],
        "TotalPerMonth",
            CALCULATE(
                COUNT('call_table'[interaction_key]),
                'int fact_helpline_chat_call_log'[target] IN {"true"} &&
                'call_table'[campaign_name] IN {"whatsapp", "calls", "chats"}
            )
    )
RETURN
    AVERAGEX(MonthlyTotals, [TotalPerMonth])

If you want the monthly average to show as a constant value across all months, use this version:

Static Monthly Average =
CALCULATE(
    [Overall Monthly Average],
    ALLSELECTED('int dim_dates'[year_month])
)

This will keep the same average across the table while still updating correctly when using the Campaign slicer.

Hope this helps. Please feel free to reach out for any further questions.

Thank you.