Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
PaulCo
Helper II
Helper II

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

1 ACCEPTED SOLUTION
mow700
Resolver I
Resolver 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])....

 

View solution in original post

2 REPLIES 2
mow700
Resolver I
Resolver 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])....

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.