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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Vahid, that just gives me a complete total which is the same each month:

It shows the total rather than a running total on both graphs (MonthName and HSMonth)

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: