Can’t determine relationships between the fields

[butterscotch]

Hello,

Above are the tables that has relationship , Project is the primary table(Column index is the primary key) and  table (Project_Details,Duration and Manual) contains index column as the foreign key.If I add columns from Project, Project_Details and Duration to any visual, it work fine however as soon as i add any column from Manual. it says following error.

but the catch is, when i add any column from table Manual , its okay if i use aggregation  but if i select "Dont summarize" the error occur. The thing is if i select aggregation formula, i wont get the output that i wanted, i want the data in column to be exactly appeared in the visual

Thank you in advance !

[butterscotch]

Sample Data:

Visual that i want(ignore the histogram, the focus is on the axis):

The output that i intended in the end is to display total area in each month for every project

[PijushRoy]

Hi @butterscotch 

Please check, there are two-way relationship between, Project & duration, Project & Manual
I am not sure, but you can insert both way relationship with Project Details table not Project table
Anyway, with your existing relationship
If you 1st bring the column from the Duration table (1.1 relationship), then if you add a column from Project or Manual table or project details table, this is work.

But try to change the relationship in your data model. If Project details is Fact table, try to connect DIM table with Fact table

[butterscotch]

hm i dont quite understand your explanation

[PijushRoy]

Hi @butterscotch 

Can you please share link for sample pbix file 
or sample data for 4 tables
and what is the visual you are looking for (screenshot)