Missing Values in Running Total | Animated Running Bar Chart

[kbansal]

Hi Everyone,

I am working on an animated bar chart, and for that I created a running total measure. In my data, few 'Vendors' have no entry for some dates. And whenever a date is missing for a vendor then that vendor is totally getting dropped from the running bar chart. Can you please help

Running Total =

CALCULATE(

SUM('All Data'[Count]),

FILTER(

ALLSELECTED('All Data'),

'All Data'[DATESUBMITTED] <= MAX('All Data'[DATESUBMITTED]) && 'All Data'[VENDORNAME] = MAX('All Data'[VENDORNAME])

)

)

[Anonymous]

Hi @kbansal ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

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

[KNP · Accepted solution]

Hi @kbansal,

It is a common problem with running totals when the data is incomplete.

The best thing to do is tidy up the data. Start with a complete date range, from your date dimension ideally, and then merge >> left join the other data onto this. Make sure to replace the null values with zeros where appropriate and then the running totals should calculate as expected.

Hope this helps.

Regards,

Kim

[lbendlin]

Please provide sanitized sample data that covers your issue, in usable format (not as a picture - inserting it into a table would be good) and show the expected outcome.