Cluster column and line chart not showing totals properly with slicer

[alicewang96]

I have a measure which calculates the running total of the % spent of a budget each month. The table this results in looks like:

The expression used in the measure is:

% of Budget Spent = DIVIDE(CALCULATE(SUM(table_1[Amount Paid]),FILTER(ALLSELECTED(table_1), RELATED(date_table[Date])<=MAX(date_table[Date]))),1000000,0)

with $1M being the total budget.

I also have a cluster chart which should separate the % displayed in the table by whether it is in or out of state. I have a slicer at the top of the page which allows users to filter. When the filter is set to "All" the % spend for the graph is displayed incorrectly. For in-state, the graph displays the total % spent (in state and out of state), while the number displayed for out of state is completely incorrect:

However, when the filter is set to either in-state OR out of state, the chart displays the correct %. 

How can I adapt my measure to do this?

[V-lianl-msft]

Hi @alicewang96 ,

It's hard to analyze the problem just with formula and see if you can share the sample pbix file through a cloud service like onedrive for business.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.