POWER PIVOT Running total graph breaks?

CorporateEmo 1 Reputation point
2022-03-23T09:11:48.823+00:00

185949-image.png

Hi, Microsoft. Need help in figuring this out. The above screenshot is the graph I made using PowerPivot and DAX formula. For reference, here's the formula:

=CALCULATE(COUNTA(Actual[Actual - M4]),FILTER(ALLSELECTED(DataDateM4[Date]),ISONORAFTER(DataDateM4[Date],MAXA(Actual[Actual - M4]),desc)))

here's the Pivot Table as well:

186036-image.png

The yellow ones are what cause the breakage in the graph. Can you help me figure out the right DAX formula? Thank you

Community Center Not monitored
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.