Need help fixing my win rate formula

[frenchiedc87]

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

[amitchandak · Accepted solution]

@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])))

[az38 · Accepted solution]

@frenchiedc87 

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)))))
)

[amitchandak · Accepted solution]

@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])))