Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Connect 2 slicers with the same values

I have 2 tables that are connected via relationship. Each of the 2 tables has a column called Segment that contains the same distinct values. In PBI report, I have one visual using data from one tabl...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Anonymous 
    That seems that you need to modify your model.
    Try to :

    union those tables (2 with segment and value) or to manupulate relationships with dax inside measures using userelationship function
    https://www.youtube.com/watch?v=2NW2XKblrME

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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

Hi Anonymous 
You need to create third table "Segment" with uniwue values from both of your 2 tables and modify relationship one to many from both of your 2 tables to this third.

 

 

 

Link to the sample file 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks Ritaf1983 - both of the tables have a one to many relationship with Date table so when I create a relationship between them for Segment, it turns off the Date relationship. I can't turn on both relationships, but I need both connections. 

    • Ritaf1983's avatar
      Ritaf1983
      Icon for Super User rankSuper User
      3 years ago

      Anonymous 
      That seems that you need to modify your model.
      Try to :

      union those tables (2 with segment and value) or to manupulate relationships with dax inside measures using userelationship function
      https://www.youtube.com/watch?v=2NW2XKblrME

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