DAX Measure for last value of running total?

[longtran]

Hello community!

I'm struggling to create a DAX measure to pick out the running total result on my last date (14/07/2023).
The purpose of this is to put a dot in my running total graph/sparkline (marked as red cross). As you can see my attempt of this formular shows 57, whereas it should be 5701.

Many thanks in advance and I look forward to your response.

[amitchandak]

@longtran , Create a meausre like

M1=

var _max = maxx(allselected(Table), Table[Date])

return

calculate(Sum(Table[Values]), filter(allselected(Table), Table[Date] <= _max) )

or

M1=

var _max = maxx(all(Table), Table[Date])

return

calculate(Sum(Table[Values]), filter(all(Table), Table[Date] <= _max) )

Use this as second line/value and then enable marker for this line

[longtran]

Hi amitchandak,

Many thanks for your response. I've tried both formulas but they gave me a single line across the chart instead of a dot for the final day. Please see below, thanks again!