Forum Discussion

JAgius's avatar
JAgius
Regular Visitor
5 years ago
Solved

Sports Modeling

Hey Guys,

 

I have a model for Pitcher at baseball MLB. I'm struggling with having an opposite Filter. While clicking at a pitcher, I want to list all hitters from the opponent of the pitcher. At the moment he will show me all Hitters from the Team of the pitcher.

 

here's an example to understand the situation, I clicked Kershaw and he should list HItters from Miami and not LAD (Pitcher Team). Any way to realize that?

 

Thanks in advance,

Jonas

 

 

  • Hi  JAgius ,

     

    Have you created a relationship between the two tables such as below?

    If so,you would see:

    For my sample .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

1 Reply

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support

    Hi  JAgius ,

     

    Have you created a relationship between the two tables such as below?

    If so,you would see:

    For my sample .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!