https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Winrate-calculated-by-TRUE-OF-FALSE/m-p/2936065#M96763 <LI-CODE lang="markup">WinRate = VAR total = COUNTROWS('YourTable') VAR won = CALCULATE( COUNTROWS('YourTable'), YourTable[won] = TRUE() ) RETURN DIVIDE(won, total)</LI-CODE> Tue, 29 Nov 2022 14:16:16 GMT lukiz84 2022-11-29T14:16:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Winrate-calculated-by-TRUE-OF-FALSE/m-p/2936033#M96760 <P>Hello, I would like to count the winrate % for each player. I have a table with 2 columns [player] and [won]. The player column is text and won is TRUE/FALSE.&nbsp;</P> Tue, 29 Nov 2022 14:07:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Winrate-calculated-by-TRUE-OF-FALSE/m-p/2936033#M96760 Pan_Forex 2022-11-29T14:07:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Winrate-calculated-by-TRUE-OF-FALSE/m-p/2936065#M96763 <LI-CODE lang="markup">WinRate = VAR total = COUNTROWS('YourTable') VAR won = CALCULATE( COUNTROWS('YourTable'), YourTable[won] = TRUE() ) RETURN DIVIDE(won, total)</LI-CODE> Tue, 29 Nov 2022 14:16:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Winrate-calculated-by-TRUE-OF-FALSE/m-p/2936065#M96763 lukiz84 2022-11-29T14:16:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Winrate-calculated-by-TRUE-OF-FALSE/m-p/2936098#M96768 <P>Thank you very much!</P> Tue, 29 Nov 2022 14:24:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Winrate-calculated-by-TRUE-OF-FALSE/m-p/2936098#M96768 Pan_Forex 2022-11-29T14:24:43Z