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.
tamerj1
Community Champion
Community ChampionAnonymous
Yes that will do. However, not sure if that anything to do with blank result. Actually, without the 2nd filter the result should count more rows.