Last Value used as line to beat

[MrNoob]

So I have a line chart and bar chart combo,  The bars are the industry average, then the blue line is my companies performance and the dotted line is a metric we want to beat.  Now the dotted line is a 7 day moving average.  I am wishing to take the last value from 3/6/18 and use that value for the rest of the dates.  To make a straight line all the way across.  What would i insert into my measure to make this so, below is my current measure

SS = DIVIDE(CALCULATE(SUM(OAG[Total Seats]),OAG[oper_carr]="__"),(CALCULATE(SUM(OAG[Total Seats]),ALL(OAG[oper_carr]))))


SS MA = 
CALCULATE([SS], 
          DATESINPERIOD('Date'[Date], 
                        LASTDATE('Date'[Date]),-7, DAY
                       )
         )

[Ashish_Mathur]

Hi,

I am unclear.  Do you want to insert a 4th line (which will be parallel to the X axis) with a value which equates to the value on the last date?

Please clarify.

[MrNoob]

I want to make the black dashed line run parallel to the x axis. whit the value equating to the last value, which in this case is 3/6/2018 value.

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=CALCULATE([ss],DATESBETWEEN('Date'[Date],MAXX(ALL('Date'[Date]),'Date'[Date]),MAXX(ALL('Date'[Date]),'Date'[Date])))

If this does not work, share the link from where i can download your PBI file.