Forum Discussion
Helper IICan’t determine relationships between the fields
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 !
4 Replies
- PijushRoy
Community Champion
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
butterscotchhm 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)
- 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
