Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi everyone!
I'm working with sports data and would like to know if there is any way to find a string inside a column (also a string) filtered for a third column. For example, the one below:
- To find the Player column (from Player table) inside the FiveOnCourt column (from Plays table) based on Full_Game column. The goal is to get how many games one player played (every game has a different value in Full_Game column).
Secondly, I would like to know if, filtering for the MAX of Índice column + a Full_Game (to do the search in a game), it's possible to do the same exercise [To find the Player column (from Player table) inside the FiveOnCourt column (from Plays table) based on Full_Game column. The goal is to get how many games one player played.]. The goal here is to know if a player started the game. If the string (Player) is in FiveOnCourt field, there would be yes and a starting five player, otherwise, the Player would not be in Starting Five.
Add you the pbix file and raw data: https://drive.google.com/drive/folders/1BxVWCtoHkcQYnDfOpqmYFpFgXpoEIPOt
Thank you for your time.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 31 | |
| 19 | |
| 12 | |
| 10 |