Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |