We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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
User | Count |
---|---|
67 | |
61 | |
47 | |
35 | |
32 |
User | Count |
---|---|
87 | |
72 | |
57 | |
51 | |
45 |