cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Isaac Frequent Visitor
Frequent Visitor

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

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 graph.jpgOriginal 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.jpgActually 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.jpgExpected 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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @Isaac ,

 

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)
	)
)

11.png

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
3 REPLIES 3
Community Support Team
Community Support Team

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

Hi @Isaac ,

 

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

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Isaac Frequent Visitor
Frequent Visitor

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

Hi Xiaoxin,

 

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

 

Thanks,

Isaac

Community Support Team
Community Support Team

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

Hi @Isaac ,

 

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)
	)
)

11.png

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |