Forum Discussion
Problem with DAX calculating a value using filters from two tables
First of all, greetings. This is my first post. As a new user my knowledge is limited but I will try to grow in this data world. In this example, I am trying to calculate against how many 'top' t...
Could it be, Clubs filter Games, but Games (opponent_id) can't filter back to Clubs (club_id)?
The related column is club_id in both, because this dataset I was given has 'two games' for every actual game, one hosting 'Home', the other hosting 'Away'.
I think I should insert kind of a "filter" inside the function, comparing 'opponent_id' with 'club_id' and 'category' = 1... or something like that.
My knowledge of DAX is very limited and I don't know how to even write long sentences in the correct order.
