Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
105 | |
98 | |
38 | |
30 |