Forum Discussion

dnaman's avatar
dnaman
Helper I
9 years ago
Solved

Need help calculating % Win Rate

 Hi All, Fairly new to Power BI and what 'm trying to do is calculate the %Win Rate for a table that is showing all our sales opportunities.   Each sales opp, has a status and i want to calculate ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago
    Measure = CALCULATE(COUNT(Table[Column]),FILTER(Table,[Status]="WON")) / CALCULATE(COUNT(Table[Column]),ALL(Table))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I want to make a slight aleration to the formula that you've provided in the past. Instead of divided the data by the total, I want to divide it by win +loss.

 

Bottom line I want to see win / (win+loss)

 

Thought, something is not working -- I am a novice

 

Win Rate = CALCULATE(COUNT(CorpPipeline_ALL[Title]),FILTER(CorpPipeline_ALL, CorpPipeline_ALL[Opportunity Status]="won"))/ CALCULATE(COUNT(CorpPipeline_ALL[Title]),FILTER(CorpPipeline_ALL, CorpPipeline_ALL[Opportunity Status] ="won" AND "lost)))))
 
I would grealy appreciate any help
lorenz0210's avatar
lorenz0210
Helper I
6 years ago

Hi, 

 

I have several statuses and need help with the dax formula. Also a slight alteration. 

 

Basically here are the statuses: 

Win, Loss & Kept-In-House. 

 

To get win the Win Ratio, I need help for dax that will convert this formula

Win Ratio = Win/ Loss + Kept-In-House. 

 

Any help would be greatly appreciated. 

 

Thank you.