Forum Discussion
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
- mow700Resolver I
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])....
- PaulCoHelper II
Thanks, I managed to work it out using the link.