Understanding the cannot determine relationship between the fields error in Power BI

Why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix.