Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Running Total

I have a simple data model recording accidents per month and want to create a bar graph showing month accidents and a running total.   Normally this wouldn't be an issue but our Accidents data uses...
Need Help
VahidDM's avatar
VahidDM
Super User
4 years ago

It would be better if you shared a sample of your data or the PBIX file.

BTE, try this:

Meausre=
CALCULATE(
    [AccidentsTy],
    FILTER(
        all(Data),Data(date)<=max(calendar(date)
)
)

 

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

 

Appreciate your Kudos!!

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Vahid,

 

Almost there. is there a way to account for zero values. Currently it looks like this:

If i use the measure that adds 0 values for the barchart i get the result below: