USERELATIONSHIP not working

[roxieli123]

I'm currently building a billing report, which I have "Account" table and "Billing" Table, between them there are two relationships that are needed in different tabs, one of them being

Account"[Account Number]  one-to-many "Billing"[Account Number]
the other is:
"Account"[Account Number] one-to-many "Billing"[Payment Account Number]

when I make the first one active, second one inactive and use USERELATIONSHIP for second relationship, my query just keeps running and running but never return results and end up showing error message saying "exceed the limit of 1000000 rows"

I tried the reverse (make first deactive, second active), it is the same situation where it doesnt return any results and becomd error after a few mins

However, when I dont use USERELATIONSHIP, and make the relationship I need at the time active(simply delete the USERELATIONSHIP part of the DAX and make that relationship active), it returns the correct result right away

Since I need both of the relationsihps in different places of the report, I will have to use USERELATIONSHIP, however it seems to me that the USERELATIONSHIP function is just not working for me, and that I am sure the actual relationship (active or Inactive) are correct because I test it out.

Can anyone help me with this?