Measure based on looking for a string inside another string

sfernamer — Thu, 20 Jul 2023 15:15:32 GMT

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.

topic Measure based on looking for a string inside another string in DAX Commands and Tips

Measure based on looking for a string inside another string