Data Model Problem

[Anonymous]

Dear Community, 

Hope you're doing ok! I have the following problem. I would like to have a matrix visualization, where the rows has to show BU (Buiness Unit) and the Columns to show risk code (after that i will add the values).

However, when i do it i got the following message, which i understand as i don't have relationship between both tables (both of them used as primary keys).

Here's my data model below. I tried to make the Risk code and Agings relationship "both". Same with the BU and BU lookup table, but doesn't seem to work. Can you please help me establish relationship between the 2 tables?

All due repect, 

Atanas

[AllisonKennedy · Accepted solution]

ah, interesting one. You may need to add the values before it will recognize the relationship, which in your data model is a tricky relationship as it goes through the BU and SalesInvoiceNumber tables, so depending on what your value is, and if the cross filter directions and relationships work with that value.

Try adding this measure to the values and see what happens as a starting point: 

LinkValue = 1

[Anonymous]

When added the values it worked! 

Thank you so much Allison!

Take care, 

Atanas