Forum Discussion

JayCee's avatar
JayCee
New Member
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 JayCee 
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?

  • JayCee's avatar
    JayCee
    New Member
    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

      JayCee 

      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.