Forum Discussion

kbansal's avatar
kbansal
Frequent Visitor
4 years ago
Solved

Missing Values in Running Total | Animated Running Bar Chart

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])
)
)
Need Help
  • KNP's avatar
    KNP
    4 years ago

    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

3 Replies

  • KNP's avatar
    KNP
    Super User
    4 years ago

    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's avatar
    lbendlin
    Super User
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.