Relationships not working even though they have been created

[ajprosser]

I have created a relationship between a table which has a unique set of asset codes (A) with two other tables on asset code (B and C).

If I put a field from B into a visualisation table it works but as soon as I add a field C I get a relationship error. Or the other way around.

I have attached two screenshots - one of the error message and one of the relationships I've set up.

The formating for asset code in all three tables is Text.

I've run out of ideas and cannot seem to find a similar issue in the forums.

[v-jiascu-msft · Accepted solution]

Hi @ajprosser,

I'm afraid we can't use it like that. It's quite clear in the example below. What's the result that you were going to achieve?

Now, we create a table visual.

asset code    asset classification       product type

computer     electricl equipment      ??? (type 1? type 2? type 3? type 4?)

Best Regards,

Dale

[ajprosser]

Thanks Dale @v-jiascu-msft - I saw what was going on after I posted in abject frustration! My bad