Forum Discussion
Relationship Between Two Tables Calculation
I have a common column to connect two tables but when I filter by branch , flag & type it gives me the total of target. How do I solve this? I need the ID column only to connect the data.
Table 2
Table 1
1 Reply
moses07_ferns - Just create a physical relationship between the two tables, using the ID column.
This article has lots of guidance on relationships in Power BI: https://triangle.im/power-bi-mistake-7-why-bi-directional-relationship-issues-will-cause-headaches/#:~:text=Key%20relationship%20features%3A%20Cardinality%20and%20cross%2Dfilter%20direction and here: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
