Running total not working (count rows)

[mwinds]

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?

[some_bih]

Hi @mwinds 

check link for example ( part Sales RT), usually best practice is to use Date / Calendar table

https://www.sqlbi.com/articles/computing-running-totals-in-dax/ 

Hope this help, kudos appreciated.

[Anonymous]

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.