cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mzrkwcz Helper I
Helper I

Re: Reporting with many to one to many relationships

You did not get error because you are not listing activities but summarizing them. Change "Activity ID" from "Count" to "Don't summarize" and you have the problem.

 

I begin to think it's the issue with the visual not understanding the relation properly.

Super User IV
Super User IV

Re: Reporting with many to one to many relationships

Hi @mzrkwcz

 

Ok that makes sense then because it is not aggregating the value but wanting to show the ActivityID

 

In that instance I would potentially merge the data together in the Query Editor





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

mzrkwcz Helper I
Helper I

Re: Reporting with many to one to many relationships

Well, I guess that's the solution I will use, although I would prefer to just use the relation 😕

 

Thank you, gualvaq.

Super User IV
Super User IV

Re: Reporting with many to one to many relationships

hi @mzrkwcz

 

Sometimes that is often the easiest and most robust solution instead of spending a lot of time trying something else out!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors