Forum Discussion

joshuavd's avatar
joshuavd
Frequent Visitor
10 years ago
Solved

DAX Counting across two tables with multiple columns

I have two tables representing our foosball games played in office.  The first is what is generated by our software that has these columns:

 

A game can either be a single or doubles
 I

 

I have a second table that I want to identify if the game was a doubles or singles game.  I think of it as   if(Count of game = 2, "singles","doubles") but I can't figure out how to make this work.  Below is what I have done but it doesn't display 2s and 4s like I would expect...  Any help would be great, thanks!

 

 

Need Help
  • Sean's avatar
    Sean
    10 years ago

    joshuavd 

    Type = IF ( COUNTROWS ( RELATEDTABLE('Foosey') ) = 2, "Singles", "Doubles")

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago
    Type = 
//First get the number of players by counting the related rows in the Foosey table
Var Players = CALCULATE(COUNTROWS(Foosey),RELATEDTABLE(Games))
RETURN
  IF(Players = 2,"Singles","Doubles")

    This assumes a relationship between Foosey and Games tables based upon Game columns. 

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      10 years ago

      joshuavd 

      Type = IF ( COUNTROWS ( RELATEDTABLE('Foosey') ) = 2, "Singles", "Doubles")

      • joshuavd's avatar
        joshuavd
        Frequent Visitor
        10 years ago

        Thanks!  I had tried this previously but it wasn't working, on further investigation I realized that I had not created a relationship between the tables... rookie mistake!  Really appreciate it!