Straight Average Line in a Line and Stacked Column Chart

[The8]

Hi,
I have two tables
Table 1 by Name "Sales" in which I have columns Date, Selling Price.
Table 2 by Name "Orders" in which I have columns Date, Orders Price.

Both these tables are in relationship with other Date Table.
(In both tables I have values for every single in each month)

I have used Line and Stacked Column Chart to visualise Selling Price and Orders Price as below Y-Axis with Date on X-Axis

I want to also calculate DAX measure for Average of Selling Price but this should be represented in a straight line in Line and Stacked Column Chart. This measure as to change dynamically according to drill up or drill down and also as per changes in filter. (Date etc..)

For example :

I need DAX measure for Average Selling Price in Line & Stacked column Chart as below

The below figure is for Clusterd Column Chart-For example

Any suggestions..!?

Thanks in advance.

[ray_aramburo]

Try adjusting the filter on the measure to ALLSELECTED or ALLEXCEPT and using your Date field as reference there.

[ray_aramburo]

First create a measure for your Average. Since you want is as a straight line (meaning average of all your data) you'll need to use CALCULATE and ALL Filter.

Average Measure = CALCULATE(AVERAGE(SellingPriceValuesColumn), ALL(TableWithYourValues))

Then add the measure to the field in Line Y axis:

Find attached an example for your reference. (PS: Data is from a dummy dataset I built for training purposes)

[The8]

Hi @ray_aramburo ,
Thanks for your response and your answer.

Your answer didn't match my requirement because when I change Dates ths measure will consider complete selling prices and make it average.

I need DAX measure for Average Selling Price in Line & Stacked column Chart as below

The below figure is for Clusterd Column Chart-For example