Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Creating multiple relationships between two tables

Hello,    I am trying to make a table visual of sales data that is filtered by a "sales manager" slicer. I currently have two tables:   Responsibilities Table This table lists each "sales mana...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    You may create a measure as below. There is no relationships between two tables. If you want relationships, you may create another same table to create realtionships. The pbix file is attached in the end.

    Visual Control = 
IF(
    NOT(ISFILTERED(Responsibilities[Manager])),
    1,
    IF(
        SELECTEDVALUE(Sales[Product]) in DISTINCT(Responsibilities[Product])&&
        SELECTEDVALUE(Sales[Region]) in DISTINCT(Responsibilities[Region]),
        1,0
    )
)

     

    Then you need to put the measure in the visual level filter to filter the result.

     

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,

Concatenate the two-column in both the tables and join

Key = [Region] & "-" & [Team]

 

and then join. It should work.