Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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.
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
Solved! Go to Solution.
@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
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
@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
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 52 | |
| 45 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 108 | |
| 108 | |
| 39 | |
| 33 | |
| 25 |