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.

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

RB_Barbour-ABI you can PM me if you want to do a quick zoom to look together