Forum Discussion

PaulCo's avatar
PaulCo
Helper II
8 years ago
Solved

Cumulative Formula Measure

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

  • 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])....

     

2 Replies

  • 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's avatar
      PaulCo
      Helper II

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