cancel
Showing results for
Did you mean:
Helper I

## Need help fixing my win rate formula

I am trying to create a win rate formula which should be win rate= 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)))))

Help will be much appreciated

Thanks

A
2 ACCEPTED SOLUTIONS
Super User IV

@frenchiedc87 , try

Win Rate = divide(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] in {"won" , "lost"})))
or , In case there only two values won and lsot

Win Rate = divide(CALCULATE(COUNT(CorpPipeline_ALL[Title]),FILTER(CorpPipeline_ALL, CorpPipeline_ALL[Opportunity Status]="won")),
CALCULATE(COUNT(CorpPipeline_ALL[Title])))

Proud to be a Super User!

Super User II
``````Win Rate = DIVIDE(
CALCULATE(COUNT(CorpPipeline_ALL[Title]),FILTER(ALL(CorpPipeline_ALL), CorpPipeline_ALL[Opportunity Status]="won")),
CALCULATE(COUNT(CorpPipeline_ALL[Title]),FILTER(ALL(CorpPipeline_ALL), CorpPipeline_ALL[Opportunity Status] ="won" ||  CorpPipeline_ALL[Opportunity Status] ="lost)))))
)``````

do not hesitate to give a kudo to useful posts and mark solutions as solution
2 REPLIES 2
Super User II
``````Win Rate = DIVIDE(
CALCULATE(COUNT(CorpPipeline_ALL[Title]),FILTER(ALL(CorpPipeline_ALL), CorpPipeline_ALL[Opportunity Status]="won")),
CALCULATE(COUNT(CorpPipeline_ALL[Title]),FILTER(ALL(CorpPipeline_ALL), CorpPipeline_ALL[Opportunity Status] ="won" ||  CorpPipeline_ALL[Opportunity Status] ="lost)))))
)``````

do not hesitate to give a kudo to useful posts and mark solutions as solution
Super User IV

@frenchiedc87 , try

Win Rate = divide(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] in {"won" , "lost"})))
or , In case there only two values won and lsot

Win Rate = divide(CALCULATE(COUNT(CorpPipeline_ALL[Title]),FILTER(CorpPipeline_ALL, CorpPipeline_ALL[Opportunity Status]="won")),
CALCULATE(COUNT(CorpPipeline_ALL[Title])))

Proud to be a Super User!

Announcements