Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I want to count the wins from the dataset below. The stage Fin refers to finals and there are 7 games in each final, so the games 1-5 in 1991 finals and 1-6 in 1992 is final games for that period, and I need to find if the team has won more than or equal to 4 times out of those games played. Result gives me the status Win (W) and Loss (L).
So ideally, in 1991 team has lost game 1 and won other 4 games (2-5), so that gives me count 1 and so on.
My stage also consists of other games (Qtrfin, EC1, EC2) as well, but I'm concerned about the Fin stage.
Date | Stage | Games | Result |
02-06-1991 | FIN | 1 | L |
05-06-1991 | FIN | 2 | W |
07-06-1991 | FIN | 3 | W |
09-06-1991 | FIN | 4 | W |
12-06-1991 | FIN | 5 | W |
03-06-1992 | FIN | 1 | W |
05-06-1992 | FIN | 2 | L |
07-06-1992 | FIN | 3 | W |
10-06-1992 | FIN | 4 | L |
12-06-1992 | FIN | 5 | W |
14-06-1992 | FIN | 6 | W |
09-06-1993 | FIN | 1 | W |
11-06-1993 | FIN | 2 | W |
13-06-1993 | FIN | 3 | L |
16-06-1993 | FIN | 4 | W |
18-06-1993 | FIN | 5 | L |
20-06-1993 | FIN | 6 | W |
05-06-1996 | FIN | 1 | W |
07-06-1996 | FIN | 2 | W |
09-06-1996 | FIN | 3 | W |
12-06-1996 | FIN | 4 | L |
14-06-1996 | FIN | 5 | L |
16-06-1996 | FIN | 6 | W |
01-06-1997 | FIN | 1 | W |
04-06-1997 | FIN | 2 | W |
06-06-1997 | FIN | 3 | L |
08-06-1997 | FIN | 4 | L |
11-06-1997 | FIN | 5 | W |
13-06-1997 | FIN | 6 | W |
03-06-1998 | FIN | 1 | L |
05-06-1998 | FIN | 2 | W |
07-06-1998 | FIN | 3 | W |
10-06-1998 | FIN | 4 | W |
12-06-1998 | FIN | 5 | L |
14-06-1998 | FIN | 6 | W |
Thanks,
Ankit
Solved! Go to Solution.
Not sure if this is the result you want, but I didn't find the team information in your data source, so I created a calculated column Year for dimension.
#Win =
VAR _Table =
CALCULATETABLE (
SUMMARIZE ( 'Table', 'Table'[Year], 'Table'[Games], 'Table'[Result] ),
'Table'[Stage] = "FIN",
'Table'[Result] = "W"
)
VAR _GROUPBY =
GROUPBY ( _Table, 'Table'[Year], "@Win", SUMX ( CURRENTGROUP (), 1 ) )
VAR _Filtered =
FILTER ( _GROUPBY, [@Win] >= 4 )
RETURN
COUNTROWS ( _Filtered )
Not sure if this is the result you want, but I didn't find the team information in your data source, so I created a calculated column Year for dimension.
#Win =
VAR _Table =
CALCULATETABLE (
SUMMARIZE ( 'Table', 'Table'[Year], 'Table'[Games], 'Table'[Result] ),
'Table'[Stage] = "FIN",
'Table'[Result] = "W"
)
VAR _GROUPBY =
GROUPBY ( _Table, 'Table'[Year], "@Win", SUMX ( CURRENTGROUP (), 1 ) )
VAR _Filtered =
FILTER ( _GROUPBY, [@Win] >= 4 )
RETURN
COUNTROWS ( _Filtered )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
24 | |
17 | |
12 | |
11 | |
10 |
User | Count |
---|---|
32 | |
25 | |
16 | |
14 | |
13 |