Chris has poste below on his blog. Interesting enough to think if we can do the same with DAX. The short answer is yes. But how? If you like challenges, roll up your sleeves and get to it. Come back and show us what you have
Calculating The Value Of Overdue Invoices Using Many-To-Many Relationships in SSAS Multidimensional | Chris Webb's BI Blog
sample file can be found here
https://onedrive.live.com/?cid=7DF5E31C189063EC&id=7DF5E31C189063EC!124
Calculating The Value Of Overdue Invoices Using Many-To-Many Relationships in SSAS Multidimensional | Chris Webb's BI Blog
sample file can be found here
https://onedrive.live.com/?cid=7DF5E31C189063EC&id=7DF5E31C189063EC!124