Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago
Solved

Many-to-Many Question

Hi Community,

 

I have this PBIX File, I simply wanted to know if it's possible to make it work. Although I'm hoping that someone might have an idea how to make this happen I already got the idea it's not going to be easy or even not possible.

 

 

 

 

 

 

Thank you in advance.

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    The issue here is that you need to use some sort of aggregation on one of your fields like a COUNT or something. Even with the M2M relationship, there is no way for Power BI to make sense of how Project Code goes with Handled Department. Basically, it can't put them in the same row on a table because there's no aggregation or anything else that makes any sense to relate them together.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    The issue here is that you need to use some sort of aggregation on one of your fields like a COUNT or something. Even with the M2M relationship, there is no way for Power BI to make sense of how Project Code goes with Handled Department. Basically, it can't put them in the same row on a table because there's no aggregation or anything else that makes any sense to relate them together.