Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have 4 timeseries with a date, region and value column in a single table where the region column identifies the timeseries. I want to plot the values as a line chart. I have a slicer that allows me to filter the regions and diplay them as summed values looking like this:
Now I want to be able to display annual averages of the value column in another visual below to get the following:
I calculate the yearly average with a measure as follows:
```
Can anyone help me out with a DAX that first sums the values per month for the selected regions, and then gets the yearly average?
Thanks a lot!
@TimHuijsmans , Try like
YearlyAverage =
AVERAGEX(
Values( 'pbi_example'[Month Year]),
calculate(Sum('pbi_example'[value]) )
)
Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980