Forum Discussion

smileamile2's avatar
smileamile2
Resolver I
5 years ago
Solved

Relationship causing aggregation at highest level

I have 3 tables: Budget, OS Acct Master, Acct Hierarchy, Actual. The relationship is below. Note there can be multiple ERP Accts to 1 OS Acct (which I think is what's causing the issue I'm seeing). B...
Need Help
  • smileamile2's avatar
    smileamile2
    5 years ago

    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.

     

  • parry2k's avatar
    parry2k
    5 years ago

    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 

parry2k's avatar
parry2k
Super User
5 years ago

smileamile2 follow the first step first (if you read my first reply), and then you can create a measure to enable cross filter direction to both.

smileamile2's avatar
smileamile2
Resolver I
5 years ago

Thanks for the tip, I guess I haven't used crossfilter in a measure before.