Forum Discussion

RB_Barbour-ABI's avatar
RB_Barbour-ABI
Frequent Visitor
4 years ago
Solved

Calculating Win Rate by Company

I am relatively new to Power BI and I am attempting to calculate the win rate between competing companies bidding on projects.   The data is set out to have a row per company relationship and so pr...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, RB_Barbour-ABI ;

    Try it.

    the above as win number and win value.

    then create a meaure.

    Loss Number = CALCULATE(COUNT([Loss]),FILTER(ALL('Table'),[Loss]=MAX('Table'[Win])&&[Win]=MAX('Table'[Loss])))+0
    Loss value = CALCULATE(SUM([Value]),FILTER(ALL('Table'),[Loss]=MAX('Table'[Win])&&[Win]=MAX('Table'[Loss])))+0
    Total Bids = COUNT([Loss])+[Loss Number]
    Total Bid Value = SUM('Table'[Value])+[Loss value]
    Win Rate Number (%) = COUNT([Loss])/[Total Bids]
    Win Rate Value (%) = SUM('Table'[Value])/[Total Bid Value]

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, RB_Barbour-ABI ;

Try it.

the above as win number and win value.

then create a meaure.

Loss Number = CALCULATE(COUNT([Loss]),FILTER(ALL('Table'),[Loss]=MAX('Table'[Win])&&[Win]=MAX('Table'[Loss])))+0
Loss value = CALCULATE(SUM([Value]),FILTER(ALL('Table'),[Loss]=MAX('Table'[Win])&&[Win]=MAX('Table'[Loss])))+0
Total Bids = COUNT([Loss])+[Loss Number]
Total Bid Value = SUM('Table'[Value])+[Loss value]
Win Rate Number (%) = COUNT([Loss])/[Total Bids]
Win Rate Value (%) = SUM('Table'[Value])/[Total Bid Value]

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

RB_Barbour-ABI's avatar
RB_Barbour-ABI
Frequent Visitor
4 years ago

Hi v-yalanwu-msft ,

 

Thank you very much, this solution is excellent.

 

Unfortunately, if I add a Total to the table to show the selected company's overall numbers, the loss measures return the last company number and not the total.

 

 

 

Is there any way around this?