Forum Discussion
Ambiguity between data table tables (date)
- 6 years ago
Going from calendar-> Counter Flaws
One path is along the relationship connecting both tables. Calendar-> Counter Flaws
The second path would be from Calendar->vWebSitesEform-> vWebSites->Counter Flaws
Powerbi wouldn't let the relationship be created from Calendar->vWebSitesEform because it can't allow 2 paths from calendar-> Counter Flaws. Because it doesn't know which way to go (path 1 or path 2).
You're right about it
I changed the relation between vWebsitesEform and vWebsites by (*..1) and the direction of filter from vWebsite to vWebSitesEform . The result is i can active now the link between Calendar and vWebSitesEform.
But I don't understand the reason. Could you explain me please ?
Going from calendar-> Counter Flaws
One path is along the relationship connecting both tables. Calendar-> Counter Flaws
The second path would be from Calendar->vWebSitesEform-> vWebSites->Counter Flaws
Powerbi wouldn't let the relationship be created from Calendar->vWebSitesEform because it can't allow 2 paths from calendar-> Counter Flaws. Because it doesn't know which way to go (path 1 or path 2).
- Anonymous6 years agoNot applicable
I understand now. Thank you so much !