Cumulative Formula Measure

[PaulCo]

I've read some of the other threads and have tried to apply to my dashboard but am having troubles with the Formula. 

I am trying to count the number of registrations that we have over a period of time so that I can plot the cumulative numbers on a graph. 

Table Name = Stratas_SC_Registration_Prod

Date Field = [Supplier Registered Date]

This is the formula that I tried:

Cumulative Registrations = CALCULATE (Count(Stratas_SC_Registration_Prod [Supplier Company Name]), FILTER(ALL(Stratas_SC_Registration_Prod[Supplier Registered Date].[Date]),Stratas_SC_Registration_Prod[Supplier Registered Date].[Date] <= MAX (Stratas_SC_Registration_Prod[Supplier Registered Date])))

However this only returned the same values to me. Can someone point out where I am going wrong? 

Thanks

Paul

[mow700 · Accepted solution]

Have you reviewed the dax pattern for this yet?  I found this article very helpful personally.  

http://www.daxpatterns.com/cumulative-total/

Perhaps you are looking for the distinct count?

 CALCULATE ( DISTINCTCOUNT(Stratas_SC_Registration_Prod [Supplier Company Name])....

[PaulCo]

Thanks, I managed to work it out using the link.