Forum Discussion

procurtstinate's avatar
procurtstinate
Frequent Visitor
8 years ago
Solved

Win rate % not filtering by date slicer

I'm trying to calculate the win rate of our sales opportunities, I have used the following measure to calculate the win rate %   Win Rate = CALCULATE(COUNT(opportunities[name]),FILTER(opportunities...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi procurtstinate,

     

    When you add a ALL to your formulas it gets all the information removing the slicer from the filters.

     

    In this case you should use the measure like this.

     

    Win Rate = CALCULATE(COUNT(opportunities[name]),FILTER(opportunities,[Status]="Won")) / CALCULATE(COUNT(opportunities[name]))

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi procurtstinate,

 

When you add a ALL to your formulas it gets all the information removing the slicer from the filters.

 

In this case you should use the measure like this.

 

Win Rate = CALCULATE(COUNT(opportunities[name]),FILTER(opportunities,[Status]="Won")) / CALCULATE(COUNT(opportunities[name]))

Regards,

MFelix

procurtstinate's avatar
procurtstinate
Frequent Visitor
8 years ago

It's as simple as that! Thanks for the tip, problem solved :smileyhappy: