NFL Win %

[mayenscb]

I am trying to get a card to show the win % of teams that I have listed on a bar chart. The formula in excel would be =# of wins/(# of wins + # of losses). Is there a way I can do this in Power BI and the win % will change with each team selected?

[amitchandak]

@mayenscb , Do you have meausre for Win and Loss.

Try like

divide([Win#],[Win#]+[loss#])

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[mayenscb]

Thank you for your help, below is a screenshot of the data that I am using. Columns G&J are the ones that I want to interface with each other. I want to know if a team is the home team what is their win%.

[v-kelly-msft · Accepted solution]

Hi  @mayenscb ,

Create a measure as below:

Home win% = 
var _winscore=CALCULATE(SUM('Table'[Score_home]),FILTER(ALL('Table'),'Table'[team_home]=MAX('Table'[team_home])&&'Table'[Home team outcome]="Win"))
var _losescore=CALCULATE(SUM('Table'[Score_home]),FILTER(ALL('Table'),'Table'[team_home]=MAX('Table'[team_home])&&'Table'[Home team outcome]="Loss"))
Return
DIVIDE(_winscore,_winscore+_losescore)+0

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!