Forum Discussion

toddpbi's avatar
toddpbi
Helper II
8 years ago

Many-To-Many

Hello PBI community.   I have been stuck on this particular problem for a few days and cannot seem to wrap my head around it. Currently, I have sales and target data in a table that is related to ...
Need Help
SivaMani's avatar
SivaMani
Resident Rockstar
8 years ago

toddpbi,

 

Can you create two Dimension tables,

  1. DimKAM - Which has unique KAM IDs
  2. DimSA - Which has unique Sales Agent IDs

And Create the relationship between three tables,

 

  1. DimKAM to your Sales/Target table - it should be bi-directional.
  2. DimSA to your Sales/Target table - it should be bi-directional.

 

  • toddpbi's avatar
    toddpbi
    Helper II
    8 years ago

    I cannot create a relationship between these tables as there is no unique values on which to create the relationship.

    • SivaMani's avatar
      SivaMani
      Resident Rockstar
      8 years ago

      Oh Sorry,

       

      I forgot to mention, You have created those two tables and each has a single column.

      • DimKAM for KAM
      • DimSA for Sales Agent
      • toddpbi's avatar
        toddpbi
        Helper II
        8 years ago

        I already have the correct tables with unique values down the bottom (KAM Information, Sales Agent Information etc).

         

        The only table that does not contain unique values is the Hierarchy table.