Hi All!
I have a task bringing me into confusion.
Fact table with agreement net changes is given.
What I need is to calculate balance of each agreement and sum them up.
1. Could you assist me how to optimize SUMX, if number of agreements is about 100k and only part of them can be in current scope (Customer, Company etc)?
2. Is there efficient way to create precalculated Balances Fact table by Date,Counterparty and Agreement via Power Query or DAX?
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
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
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.
