Forum Discussion

mwinds's avatar
mwinds
Helper I
2 years ago

Running total not working (count rows)

Hi all,

 

I am trying to create a measure where it simply counts the number of rows in a table that have a date in the date column. 

 

The forumla I'm using does not accumulate as some months go down.

Running total of homes completed = 
CALCULATE (COUNTROWS(PropertyDetails),
    FILTER (
        ALL ('PropertyDetails'),
        PropertyDetails[Month invoiced] <= MAX(PropertyDetails[Month invoiced])
    )
)

 

Is anyone able to help please?

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi mwinds ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.