cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## 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,[Status]="Won")) / CALCULATE(COUNT(opportunities[name]),ALL(opportunities))`

However the result I'm getting doesn't appear to be calculated correctly due to my date slicer, as shown in the screenshot below the win rate is calculated at 17.96% however looking at the total opportunities and total won opportunties it should actually be 24.67%

I think this is because of the date slicer shown in the screenshot but I can't figure out what I need to change about my measure to make this work.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Win rate % not filtering by date slicer

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

3 REPLIES 3
Super User

## Re: Win rate % not filtering by date slicer

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User

## Re: Win rate % not filtering by date slicer

Not entirely sure why you need an ALL statement in the denominator of your measure, it seems completely superfluous and is probably causing the incorrect results by ignoring the date slicer

Frequent Visitor

## Re: Win rate % not filtering by date slicer

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