Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AJw1234
Regular Visitor

Struggling with Relationships

I am hoping someone can help me.  I have one table which contains a list of tasks.  I also have multiple tables where the tasks from the main table are created.  Hopefully this screenshot image will explain better.

 

IMG_1513.jpeg

 

As you can see Power BI has created the relationships from the ClustMaint table (main table) to the task tables.  These task tables will contain multiple entries of the tasks from the Main table.  When I try to create a Table report graphic I add the Task Title from ClustMaint(Main Table) and the Completed fields from all the task tables, however I get "Cant display visual.  See details."  the details are "Cant display the data because Power Bi cvan't determine the relationship between two or more fields".

 

I am under no illusion this is me messing something up so would appreciate any guidance support advice anyone can give.

 

Many thanks in advance

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@AJw1234 , if you are trying to take the Not summarized column from two fact tables , then it will give error. You can only take Not summarized column from one fact.

 

you might have to bring the column into a dim table 

 

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

View solution in original post

2 REPLIES 2
AJw1234
Regular Visitor

 Thanks for your quick reply, however, I have probably misled you as to the Task tables, basically the task tables are populated each week from the master list with the list of tasks (so mulitple entries of the same task) and engineers mark the tasks as completed in the different task lists.  Then I am trying to create a report with the responses from the task tables all in one visual.  I don't have a summarized field as far as I am aware

amitchandak
Super User
Super User

@AJw1234 , if you are trying to take the Not summarized column from two fact tables , then it will give error. You can only take Not summarized column from one fact.

 

you might have to bring the column into a dim table 

 

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors