Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
"CALCULATE"
"DAX"
"IN VALUES"
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 
If the return result is blank then the Selected Club do not exist in the Games table (as opponent) or otherise you need to double check the data taype and quality of both columns.

As side note I would say that 2nd filter "dimClubs[category] = 1" probably shall not be effective as both tables are dim tables and most propably there is no direct relationship between the two tables?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Anonymous 

      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.