Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Pan_Forex
Helper III
Helper III

Winrate calculated by TRUE OF FALSE

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. 

1 ACCEPTED SOLUTION
lukiz84
Memorable Member
Memorable Member

WinRate = 
   VAR total = COUNTROWS('YourTable')
   VAR won = CALCULATE(
       COUNTROWS('YourTable'),
       YourTable[won] = TRUE()
   )

   RETURN DIVIDE(won, total)

View solution in original post

2 REPLIES 2
lukiz84
Memorable Member
Memorable Member

WinRate = 
   VAR total = COUNTROWS('YourTable')
   VAR won = CALCULATE(
       COUNTROWS('YourTable'),
       YourTable[won] = TRUE()
   )

   RETURN DIVIDE(won, total)

Thank you very much!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.