Forum Discussion

rodneyc8063_1's avatar
rodneyc8063_1
Icon for Helper V rankHelper V
5 years ago
Solved

Many to Many Bridge Table Not Working Consistently?

So I am trying to wrap my head around PBI Many to Many relationships and was reading this article   https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-many-to-many-relationships#use-...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    rodneyc8063_1 , You can not take Unsumamrized measure both from Code_1 and Code_2. I changed visual level aggregation of name First Title (as First/Min) and it worked.

     

    Both side of one table can not have un summarized columns, Only one table can have that.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

rodneyc8063_1 , You can not take Unsumamrized measure both from Code_1 and Code_2. I changed visual level aggregation of name First Title (as First/Min) and it worked.

 

Both side of one table can not have un summarized columns, Only one table can have that.