Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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:
Solved! Go to Solution.
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 .
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 .
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!