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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Lewa
Helper I
Helper I

Cumulative Sum with required filter

Hi all! 

 

I need your help again.

 

So, 

 

Measure = 
VAR FILTER2 = FILTER(ALL(Calendary) ; Calendary[Date] <= MAX(Calendary[Date])) // <--cumulative filter
VAR FILTER1 = FILTER(Transactions ; TRUE()) // <--required filter <just for sample>
VAR RES = CALCULATE ( CALCULATE(SUM(Transactions[Cost]) ; FILTER2 ) ; FILTER1 )
RETURN RES

Problem is: 

  • without required FILTER1 its work correct: 2.PNG

 

 

  • with -- nope!1.PNG

 

1 ACCEPTED SOLUTION
Lewa
Helper I
Helper I

Solution is: 

 

RETURN CALCULATE(CALCULATE(SUM(Transactions[Cost]) ; FILTER1 ) ; FILTER2 ) //FILTER1 = FILTER(Transactions ; TRUE() )
RETURN CALCULATE(CALCULATE(SUM(Transactions[Cost]) ; FILTER(Transactions ; TRUE() ) ) ; FILTER2 ) 

-- not identical and return various dataset . 

View solution in original post

1 REPLY 1
Lewa
Helper I
Helper I

Solution is: 

 

RETURN CALCULATE(CALCULATE(SUM(Transactions[Cost]) ; FILTER1 ) ; FILTER2 ) //FILTER1 = FILTER(Transactions ; TRUE() )
RETURN CALCULATE(CALCULATE(SUM(Transactions[Cost]) ; FILTER(Transactions ; TRUE() ) ) ; FILTER2 ) 

-- not identical and return various dataset . 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors