SUMX on a large Dim table / Precalculated balances

[Mike_0828]

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?