Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
Type = IF ( COUNTROWS ( RELATEDTABLE('Foosey') ) = 2, "Singles", "Doubles")
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.
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!
@joshuavd - Glad you got it resolved, that's why I always try to call out assumed relationships when posting answers!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
98 | |
96 | |
59 | |
44 | |
40 |