Forum Discussion
Circular Reference - driving me mad!!!!
Here is my file - TEST.PBIX YOu will see it is very simple. I have a data table with 2 values in it "Labour" and "Material" and another table with "One", "Two", "Three", "Four" I have cre...
OK, let's try again. Which 2 columns, which data tables with which columns?
And the full message please.
so i have attached some screenshots - here
Page 1 - shows the current relationships that work
Page 2 - the error message when i try to create a relationship between 'Summarize (3)'[Column 1] and 'Table (2)'[Column1]
Page 3 - shows the data file 'Summarize (1)'
Page 4 - shows the data file 'Summarize (2)'
Page 5 - shows the data file 'Summarize (3)'
Does that help?
So i do not understand whu i can create the first 2 relationships, but i cannot create the last one
Apologies for late reply.
Create your summary table in Power Query or try a DAX crossjoin