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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.