Merge/Overlay two line charts

Hi IMPBI,

I don't have any information regarding you setup so I made a table with 3 columns:

• Date
• Values
• Vendor

Also created a date table to create the PY calculation.

Based on this setup I have made 3 measures:

Average Current Year = AVERAGE(Fact_table[Value])

Average Pryor Year = CALCULATE(AVERAGE(Fact_table[Value]); DATEADD('Calendar'[Date]; -1 ;YEAR))

Average no Sellers = CALCULATE([Average Current Year];ALL(Fact_table[Vendor]))

Be aware that this 3 measures may not correspond to what you have in your model, again without any addtional information is difficult to help you better, The first and third measure if no seller is select gives the exact same result so in the image below you will see the value overlaped.

Then just add this measures to your charts, look at the red line it doesn't move although I'm changing the slicer for vendor.

To have the result you need to the calculations you are asking you just need to use the ALL as a filter in your measure.

Regards,

MFelix