The most frequent 2 conditions

[Pan_Forex]

Hi guys! I try to count the most frequently played pairs of players in the same team. The [game_id] is always the same for each game, [team] is 1 or 0. I have come up with something like this so far and the max function is still missing. Maybe you have other better ideas?

player_pair = COUNTX(FILTER('table', 'table'[team] = [team] && 'table'[game_id] = [game_id]), 'table'[player])

game_id	player	team
1522	B	0
1522	A	0
1522	T	1
1522	F	1
1522	C	0
1522	H	1
1500	Y	0
1500	U	1
1500	O	1
1500	A	1
1500	B	1
1500	Z	0
1500	X	0
1500	Q	0

From the above example, it should come out that players A and B played together 2 times in the same team.

[amitchandak]

@Pan_Forex , seems like Market Basket Analysis problem

https://finance-bi.com/power-bi-basket-analysis/
https://businessintelligist.com/2017/03/27/market-basket-analysis-using-power-bi/
https://www.daxpatterns.com/usecases/market-basket-analysis/
https://www.mssqltips.com/sqlservertip/5428/market-basket-analysis-in-r-and-power-bi/