Calculate count of rows

[ajinkya1907]

Hi,

I am having below dataset

I would like to identify number of matches played by every winning team. Please note winning team can be part of Team 1 OR team 2. So if I calculate number of times winner appears in the team1 or team2, I should get the answer.

I am looking for Match_count field of below dashboard

[ajinkya1907 · Accepted solution]

Dear @Zubair_Muhammad, Thanks again for your help. It's indeed almost perfect solution 🙂

I made minor changes as I could not get SELECTEDVALUE function. Rest is all good.

Match Count of Winner Team =
VAR winnerteam =
    SELECTCOLUMNS( matches,"winner2",matches[winner])
RETURN
    CALCULATE ( COUNTROWS ( ALLSELECTED ( Matches ) ), Matches[Team1] = winnerteam )
        + CALCULATE ( COUNTROWS ( ALLSELECTED ( Matches ) ), Matches[Team2] = winnerteam )