Relationships Not Working

[Anonymous]

Hi,

I created a separate table with the same values as two other tables in my dashboard but they won't connect and i am not sure why.

Column 1 contains the same values as customer in 3 of the other tables.

Kind regards

Dominic

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[Anonymous]

Hi Dale,

It hasn't worked unfortunately, I already tried the suggested solutions before and it wasn't connecting and came up with the errors shown in the previous screenshots.

The data is exactly the same, I even created a table with one column with the exact same data and it still wouldn't connect?

Kind regards

Dominic

[v-jiascu-msft]

Hi @Anonymous,

Can you share the file? You can mask or delete sensitive parts first.

Best Regards,

Dale

[Anonymous]

What's the best way to mask the data?

[v-jiascu-msft]

Create a similar dummy one. Only keep the rows that can reproduce the issue.

Best Regards,

Dale

[Anonymous]

Hi Dale,

I have created a dummy one with dummy data that has the same structure.

The PBI file is a stripped back version of my actual file but barely. The problem is still here and the data is the same.

I have one file which has the data for two of the tables in across two different tabs and another file which holds the relationships they have.

All downloadable from https://we.tl/t-uloHL7AUfG 

Kind regards

Dominic

[v-jiascu-msft]

Hi Dominic,

The download link seems broken. Can you check it?

Best Regards,

Dale

[Anonymous]

Hi Dale,

Try this one.

https://we.tl/t-isiWzaftgb 

Kind regards

Dominic

[v-jiascu-msft]

Hi Dominic,

It's strange. The new link still shows up an error message.

Best Regards,

Dale

[Anonymous]

Hi Dale,

Try one of these links.

https://we.tl/t-vN8nhYh0b0

https://we.tl/t-D7T78bwWma

https://we.tl/t-FFxXnTVbwZ

Kind regards

Dominic

[v-jiascu-msft]

Hi Dominic,

It works now. 

How did you create the table "Customer List"? 

Does it have unique values?

It could be created like below.

Customer =
DISTINCT (
    UNION (
        VALUES ( 'Data Dump - Sales'[Customer] ),
        VALUES ( 'Data Dump - Trade Spend'[Customer] )
    )
)

A more compatible one is as follows.

Customer =
FILTER (
    DISTINCT (
        UNION (
            VALUES ( 'Data Dump - Sales'[Customer] ),
            VALUES ( 'Data Dump - Trade Spend'[Customer] )
        )
    ),
    ISBLANK ( [Customer] ) = FALSE ()
)

Best Regards,

Dale

[Anonymous]

Hi Dale,

So I created the shared fields table with all of the different columns of data that is the same as in th eother tables.

I did this by getting data from a separate Excel doc, is this not the way to do it?

Kind regards

Dominic

[v-jiascu-msft]

Hi Dominic,

Yes, you can get the data from anywhere. What is the error message exactly?

Best Regards,

Dale

[Anonymous]

Hi Dale,

The message is below.

Kind regards

Dominic

[v-jiascu-msft]

Does the table 'Customer List'[Column1] have unique values? Or blanks?

Best Regards,

Dale

[Anonymous]

Hi Dale,

What is a 'unique value' in this instance?

They should match exactly what is in the other tables under the [Customer] column, there shouldn't be any blanks as far as I am aware.

[v-jiascu-msft]

Hi Dominic,

The 'unique values' should only appear once in the column 'Customer List'[Column1]. For example, 

Customer 1

Customer 2

Customer 3

Can't be like below

Customer 1

Customer 2

Customer 1

Please check.

Best Regards,

Dale

[Anonymous]

Hi Dale,

I did send the raw data over as well for this, please see the below screenshot. It is in the first column.

When it comes to the other tables, this data is repeated in the same column as per the below screenshot.

Kind regards

Dominic

[v-jiascu-msft]

Hi Dominic,

How did you create the relationship? Which table[column] to which table[column]?

Best Regards,

Dale

[Anonymous]

Hi Dale,

The issue is I can't create the relationship.

I am looking to create a relationship between these variables across all the tables.

I retrieved data from one excel file for two of the tables and then I created a separate Excel file for the column to contain the shared vriables.

Kind regards

Dominic