Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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])....
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])....
Thanks, I managed to work it out using the link.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |