Many-to-Many Question

[ovetteabejuela]

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.

[Greg_Deckler · Accepted solution]

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]

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