toss decision

Question

Hi All,&nbsp;I have the below data which I want to represent in a pie chart showing percent of team batting first won vs team bowling first won.&nbsp;Please let me know if anything else is required.&nbsp;Team 1Team 2Toss winnerToss decisionWinnerabcxyzabcbatxyzxyzrstxyzbowlxyzrstxyzxyzbowlxyzabcxyzxyzbatabcxyzabcabcbowlabcabcrstrstbatrstrstxyzrstbowlxyzxyzabcabcbatxyzabcxyzabcbowlabcxyzrstxyzbowlrstrstabcabcbatrstabcrstabcbowlrstrstabcrstbowlabcabcrstrstbatrstxyzabcxyzbowlxyzrstxyzxyzbatxyzabcrstrstbatrst

samarth_18 · Accepted Answer

Hi&nbsp;shikhar6339&nbsp;,&nbsp;You cna create a column with below code:-Bat_or_bowl_first = if(Table_[Toss winner] = Table_[Winner] &amp;&amp; Table_[Toss decision] = "bat",1,0)Now create these two measure:-_bat_first = COUNTROWS(FILTER(Table_,Table_[Bat_or_bowl_first] = 1))_bowl_first = COUNTROWS(FILTER(Table_,Table_[Bat_or_bowl_first] = 0))&nbsp;Output:-&nbsp;Thanks,Samarth&nbsp;

Forum Discussion

toss decision

1 Reply

Related content

Architecture decision : Separate workspaces

Decision tree visual

Executive Decision Intelligence

Creating a Decision Matrix

Decision Trees in Power BI

Team 1	Team 2	Toss winner	Toss decision	Winner
abc	xyz	abc	bat	xyz
xyz	rst	xyz	bowl	xyz
rst	xyz	xyz	bowl	xyz
abc	xyz	xyz	bat	abc
xyz	abc	abc	bowl	abc
abc	rst	rst	bat	rst
rst	xyz	rst	bowl	xyz
xyz	abc	abc	bat	xyz
abc	xyz	abc	bowl	abc
xyz	rst	xyz	bowl	rst
rst	abc	abc	bat	rst
abc	rst	abc	bowl	rst
rst	abc	rst	bowl	abc
abc	rst	rst	bat	rst
xyz	abc	xyz	bowl	xyz
rst	xyz	xyz	bat	xyz
abc	rst	rst	bat	rst