Sum latest date value measure not displaying correctly in line chart

[Datafruit]

Hi all,

I hope you can help me, been driving myself nuts with this while trying a whole lot of different options, searching for new ideas, etc., etc.
But here goes, I have this measure, that works great in the purpose I had it from the start - do display the latest value per ATM name in a Table visual.
But now when I would like to use that same measure in a line chart, it just displays the latest value and has no regard to the country, but rather displays only 1 latest value in the line chart.

The measure is below: 

Measure - ATM remaining balance = CALCULATE(
    FIRSTNONBLANK(bi_atm_customer_remaining_balance[atm_remaining_balance_without_reject],""),
    FILTER(bi_atm_customer_remaining_balance,MAX(bi_atm_customer_remaining_balance[les_transaction_started]))
    )

And what it currently looks like is here:

The total amount that should be displayed in the chart should be 14 273 000, but now it just displays one of those latest values.

I hope you can help, since I've been stuck with this for while now.

[Datafruit · Accepted solution]

Got the answer from my other posting in the DAX forum. Might be that due to this being a DAX issue more than a Desktop issue, this topic was not picked up here.

If interested please reference the post here:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Summarize-a-measure-values/m-p/2044288#M45916

[lbendlin]

Do not use line charts for data that is unrelated (in your case the fill levels of the ATMs are not related to each other). Use a column chart instead.

What are you trying to show with the chart? Relative fill level?  

[Datafruit]

Hi @lbendlin I'm trying to show the fill level per country per date. But due to the need to show the latest level per ATM I have the previous measure. Now I would need to sum up those latest levels which are per ATM, but would need to be displayed by country.

At the moment the graph shows values for AL-B-002, instead on summarizing the whole plot.

[lbendlin]

You don't need a measure to show the fill level progression on the line chart. Put the reported date on the x axis and the country or ATM on the legend.

[Datafruit]

Hei, I'm not sure, why my reply yesterday had not been saved. But anyways...

I could use the method that you just described @lbendlin, but since I would like to capture in the chart only the latest transaction per transaction datetime column, then I have to opt to another way.

Below I have put a snip of the dataI have.

I would only want per atm to show the last remaining balance, which in this instance would be 841480 and it is in the first line.

The measure I have works correct when displaying with ATM codes, but when I try to use the same measure, att date on x axis and coutnry on legend, when it will just show the latest transaction for that specific date. It does not summarize the latest transactions across ATMs, but just shows the latest one.

[Datafruit]

@Greg_Deckler 

@amitchandak 

I sincerely hope you can help on this matter.