Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a plot as follows:
In this plot, I have a measure for the Avg 2021 and Avg 2022 lines shown
:
I want one line that shows the average value of the year being plotted. I have tried multiple measures but none of them produce this result.
Any help anyone can offer would be greatly appreciated.
Hi @CL7777 , can you send me a screenshot with the relationships of the dates, and what date are you using for the chart?. Thanks
Hi @CL7777 , try this measure
Average = CALCULATE(AVERAGE('Table'[Import]),ALLEXCEPT('Table','Table'[Date].[Year]))
The result:
Best regards
Thanks for your reponse @Bifinity_75. The plot that shows the bar chart is actually a measure and when I use the same idea as you had above but put averagex([measure]) instead, O get an incorrect result. the measure is:
any ideas why this might be wrong? thank you so much