Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Thanks a lot, Matt! That;s great info.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |