Sports Modeling

[JAgius]

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

[v-kelly-msft · Accepted solution]

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!