Display data in a single table both sides of the arrow

[trevrobwhite]

I'm trying to display data both sides of the Power BI directional arrow and it's resulting in the can't determain relationships error, I'm not sure why.

There are more tables but in it's simplist form, I'm trying to display data from the wiz_containers table & data from the wiz_findings table.

Wiz_containers is related to the container_images and from there Power BI should be able to get the finding data but it doesn't, I tried enabling bi-directional filtering but that made no difference.

Including data from container_images, containers & findings also errors, it's only happy when I remove the container fields.

Any tips?  Thanks in advance

[lbendlin]

take a step back and reevaluate your business scenario. Based on that create a data model with dimensions and facts.  Do not join fact tables directly.

Once you refactored the data model the visualization will work just fine.