Avoiding Many to Many with multiple Fact

[Anonymous]

I am trying to avoid a Many to Many relationship in the following scenario

2 Dimensions - 1 for Customer who places order and the other who receives the invoices 

2 Fact -  Order Details and the Bills to be paid with the billpay amount. 

Customer and Billpay id is in Customer. Customer 100, 300 & 600 have same payer. I want to bring overdue against the orders. 

I tried to summarize the customers to pick the customers who have an order for the selected period, but i will end up with many to many when i link with the pay id's. Is there a way to avoid that relationship and pick only the overdue amount? Pbix is attached. 

Trying to get the result in the below format 

Cust Id	Name	Order	Order Date	Overdue
100	DLR 1	1000	2/2/2021	$       200.00
		1025	3/18/2021
200	DLR 2	1010	2/10/2021	$       350.00
300	DLR 3	1020	3/15/2021	$       200.00
		1035	4/10/2021
400	DLR 4	1040	4/20/2021	$       350.00

https://drive.google.com/file/d/11EYZwXA1ipt2-KzMvPT9AC8cIeeDZT4_/view?usp=sharing

[aj1973]

Hi @Anonymous 

is this what you want to see?

[Anonymous]

@aj1973 

Yes. If it is in table visual it will be in that format

[aj1973 · Accepted solution]

I just linked these 2 tables

and add Balance to your table