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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

cumulative sum issue

Hi, I have the following problem: I have used the following measure to calculate the cumulative sum:

 

This should be the sum of entries in the table: 

 
mit IV = DISTINCTCOUNT(Kunde[amsidnr])
And this should be the cumulative sum:
 
IV =
CALCULATE (
KUNDE[mit IV];
FILTER(
ALL(KUNDE[INSERTDATE].[Date]);
KUNDE[INSERTDATE].[Date] <= MAX(KUNDE[INSERTDATE].[Date])))
 
The formula works fine, but when I use the measure in a graph it shows me all the upcoming months for this year with the value being the same. I only want to see the graph for the monthsuntil now. The slicers don't seem to work. I have no data for the months after January 2019. 
1 ACCEPTED SOLUTION
v-yulgu-msft
Employee
Employee

Hi @Anonymous,

 

This measure should work.

IV = 
CALCULATE (
KUNDE[mit IV],
FILTER(
ALLSELECTED(KUNDE),
KUNDE[INSERTDATE] <= MAX(KUNDE[INSERTDATE])
))

1.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

21 REPLIES 21
Anonymous
Not applicable

@AlB Thanks for the help!

 

I have a Table called KUNDE with the following columns:

 

amsidnr : a distinct number assigned to each customer

INSERTDATE : the date when the new customer was added to the table

mit IV : number of different amsidnr in the table

IV : cumulative sum of mit IV over time INSERTDATE

 

I managed to solve he issue temporarily by setting boundaries to my x-axis, but i don`t want to update those boundaries every day. Without them the visualization would show me data for all the months of 2019.  

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.