How to resolve this loop?

[wolfgangkb-work]

I have four tables with licensedata. I have a translation from licenseIDs to a real name in tables A and B, each using lookups in Table C. So I buit a relationship between the coloumns holding the Realname in table A+C and B+C. So far so good (I think).

Now comes to the trouble. In Tables A and B I also have identifiers for the license holder, again transöated by lookups in Table D.

Now, when I try to crate a relation for the coloumn between A+D or B+D it fails with a "loop detected" error. 

Tables A and B have two coloumns (productname, LicenseHOdler) that need to related to different tables, Table C and D. Otherwise - I figure - I can't display reports that filter data in tables A and B based on a vlaue from C (or D).

How can I solve this to get report how many licenses a license-holder has?

Thx

[AnthonyTilley]

can you provide a screen shot of your model or better yet provide a copy of your pbix file 

this sounds like a very simple set of connections to create so not sure why your having issues 

[wolfgangkb-work · Accepted solution]

I found out in the meantime how to work around. I tried to create relations for lookupvalue coloumns and so PowerBi was finding a circle here somewhere. I removed the LookUps and built the relations with the before-looedup coloumns. Now it works. 🙂