Forum Discussion

hoyt22's avatar
hoyt22
Helper I
1 year ago
Solved

Grouping Values into Multiple Categories

Hi all,   I'm running into issues when trying to group values into multiple categories. Example below. Smith Corp should be included in two different categories.   Company Category Smith C...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    If you use many-to-many, bridge table isn't necessary. Ensure that the relationship is single direction. 

     

danextian's avatar
danextian
Super User
1 year ago

Hi hoyt22 

You category slicer isn't working because the relationship flows from advertiser bridge to advertiser group mapping only. You can change the relationship to bi-directional to make it work. But for simplicity's sake, I'll use a many-to-many single direction relationship between advertiser group mapping and competitor spend. Test in DAX studio which one is more optimize for your use case.

hoyt22's avatar
hoyt22
Helper I
1 year ago

Thanks, danextian.

 

So, do I not need the bridge table at all? And for the mapping, does it have to be a many to many relationship or would a one to many work? I'll definitely test it, but I'm trying to work out the logic.

 

I appreciate your help!

  • danextian's avatar
    danextian
    Super User
    1 year ago

    If you use many-to-many, bridge table isn't necessary. Ensure that the relationship is single direction. 

     

    • hoyt22's avatar
      hoyt22
      Helper I
      1 year ago

      danextian Thank you! Your solution worked. I've always been wary of many to many relationships, but it seems like it should be fairly straightforward in my case and not result in any issues.