Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
Why does the original table has a one-to-many relationship with another table, but the copy of the original table has many-to-many relationship with the other table with the same columns used for connection?
With regards,
Rihards
Solved! Go to Solution.
Thank you, @amitchandak , for the quick reply!
It is not allowed to force 1-M in this case.
Banku grupēšana kopija 2 = ALL('Banku grupēšana')
Found the issue. DAX formula copies the table but adds a blank row as the last one.
Work-around for that is to use "Reference" (right-click on the table) in PowerQuery (didn't try anything in DAX)
Without the last row as blank it is possible to create 1-M relationship.
Thank you, @amitchandak , for the quick reply!
It is not allowed to force 1-M in this case.
Banku grupēšana kopija 2 = ALL('Banku grupēšana')
Found the issue. DAX formula copies the table but adds a blank row as the last one.
Work-around for that is to use "Reference" (right-click on the table) in PowerQuery (didn't try anything in DAX)
Without the last row as blank it is possible to create 1-M relationship.
@rihard505 , Force it to 1-M. Also, check there is no blank value on one side of the table. Also, The 1- M is inactive. is it working as 1-M as of now?
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |