Running total does not work when excluding a column in the line and stacked column chart

[Anonymous]

The chart below is the line and stacked column chart with AP/AR amount for column values and running total (cash) for line values. What I'd like to do is to exclude the AR amount on 2019/04/25 and see what will happen with the running total (cash) in the next few days.

Original chart

After I excluded the AR amount on 2019/04/25, I get the graph shown below which is not what I expected to get.

Actually get

What I expected to get is like the figure I made below. I think there is something to do with the DAX of running total (cash), but I have no idea how.

I put the DAX of Running total in Net due date (Cash) down below. If it may help. Any idea?

Expected to get

Running total in Net due date (Cash) = 
CALCULATE(
	[Amount],
	FILTER(
		ALLSELECTED('Cash flow analysis'[Net due date]),
		ISONORAFTER('Cash flow analysis'[Net due date], MAX('Cash flow analysis'[Net due date]), DESC)
	)
) 

PBIX file: Cash flow analysis.pbix

[v-shex-msft]

Hi @Anonymous ,

How did the amount calculated? Can you please share a pbix file with some sample data for test?

Regards,
Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin,

I have attached the pbix file in the end of the original post.

Thanks,

Isaac

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

You can remove fields which yo defined in 'allselected' function to receive all filter effect and it will display the graph you wanted:

Running total in Net due date (Cash) = 
CALCULATE(
	[Amount],
	FILTER(
		ALLSELECTED('Cash flow analysis'),
		ISONORAFTER('Cash flow analysis'[Net due date], MAX('Cash flow analysis'[Net due date]), DESC)
	)
)

Regards,

Xiaoxin Sheng