Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 = 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)))))
)
@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])))
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |