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-relationships-with-a-many-many-cardinality

 

It seemed to make sense to me, so I tried to re-create the sample data and do a very simple model to recreate the example. The example worked and was fine as shown below

State is the bridge table between [State CityData] and [State Sales] as shown

 

A pretty common Many to 1 and 1 to Many. Great.

 

Now I was trying to play around and just create my own set of data, but using pretty much the exact same idea as before

 

One bridge table between two tables. So again trying to replicate the Many to 1 and 1 to Many relationship previously

 

I was thinking to myself, c'mon why am I wasting my time this should totally work!

 

NOPE doesnt work!?!?

 

So Im totally confused - Did I miss something glaring?

 

I pretty much tried to replicate the exact same scenario that worked, just with different data. Im totally confused as to how it doesnt work on such a simple example?

 

I also uploaded a sample PBIX file here (Hopefully the link works)

 

https://drive.google.com/file/d/1AQlAnyv2c0PJreaPWk6jLrp8EUKHhbWc/view?usp=sharing

 

Any insight or advice would be much appreciated

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.

4 Replies

  • 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.

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

      Hi amitchandak 

       

      Sorry would it be possible to share how you resolved the error?

       

      You mentioned 

       

      amitchandak wrote:

      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.


      I'm just a bit cloudy on how you did these steps?

       

      I sort of understand what you mean with both tables cant use unsummarized measure, but I just wanted to see if I can get a working sample.

       

      Many thanks!

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

      Hi amitchandak 

       

      Sorry I think I got it now!

       

      So as you mentioned I took the following steps

       

      Originally the visual was failing as shown below while all the columns were set to "Dont Summarize"

       

      Now as you suggested, I changed one of the columns to instead use "First" or "Last" and NOW the visual seems to work

       

       

      Funky!

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity 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