Forum Discussion

The8's avatar
The8
Icon for Helper II rankHelper II
2 years ago

Straight Average Line in a Line and Stacked Column Chart

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 relation...
Need Help
Show and Tell
ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
2 years ago

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's avatar
The8
Icon for Helper II rankHelper II
2 years ago

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