Forum Discussion
Relationship causing aggregation at highest level
I actually took out the OS Acct Master table because it didnt' seem to actually be doing anything besides causing ambiguity. Now I have a many to many, but it works.
smileamile2 well in a larger model it is not recommended, it is a weak relationship, you should have tried changing the cross filter to both, would have worked. anyhow, just a recommendation.
If cross filter direction both worked, then you just simply added that in the measure and change the direction back to single, you would have a better data model rather these many to many
smileamile2 there are two ways to solve it, change the cross filter direction between account and os account master to both by clicking the relationship link, it is not a recommended method, or you can add a measure and make this relationship both. first test by changing the cross filter to both to see if it works.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡