Forum Discussion

rodneyc8063_1's avatar
rodneyc8063_1
Helper 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.

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi rodneyc8063_1 ,

 

It seems that you have solved the issue. Would you please try to accept the useful reply as answer to help others find it more quickly？

 

Best Regards,

Dedmon Dai