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

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.

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

Thanks a lot, Matt! That;s great info.