Using Many to Many for Running Sum
There are some well known design patterns and blogs for handling running sum commonly used on reports such as Profit and Loss Statements.
https://www.daxpatterns.com/cumulative-total/
I’ll show here an alternative approach that I commonly sue when we have a Many to Many table such as: