cancel
Showing results for
Did you mean:
Highlighted
Helper II

## DAX function related Issue

Hi,

I am using Cricket related data for one of my report. I would like to find out Maximum Strike Rate batsmans with more than 100 runs.  I am using below formula

Best Strike Rate =
var temp = FILTER(
SUMMARIZE(deliveries,
deliveries[match_id],
deliveries[Batsman],
"StrikeRate", 100* SUM(deliveries[batsman_runs])/COUNT(deliveries[Batsman])
),SUM(deliveries[batsman_runs]) >= 100)
return
MAXX(temp, [StrikeRate])

It's showing total strike rate & not the max stike rate. Kindly advise. Attached screenshot for your reference.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III

## Re: DAX function related Issue

```Best Strike Rate =
VAR temp =
FILTER (
SUMMARIZE (
deliveries,
deliveries[match_id],
deliveries[Batsman],
"StrikeRate", 100 * SUM ( deliveries[batsman_runs] )
/ COUNT ( deliveries[Batsman] )
),
CALCULATE ( SUM ( deliveries[batsman_runs] ) ) >= 100
)
RETURN
MAXX ( temp, [StrikeRate] )```
Try my new Power BI game Cross the River
3 REPLIES 3
Highlighted
Super User III

## Re: DAX function related Issue

```Best Strike Rate =
VAR temp =
FILTER (
SUMMARIZE (
deliveries,
deliveries[match_id],
deliveries[Batsman],
"StrikeRate", 100 * SUM ( deliveries[batsman_runs] )
/ COUNT ( deliveries[Batsman] )
),
CALCULATE ( SUM ( deliveries[batsman_runs] ) ) >= 100
)
RETURN
MAXX ( temp, [StrikeRate] )```
Try my new Power BI game Cross the River
Highlighted
Helper II

## Re: DAX function related Issue

Could you please explain why calculate function made the difference? I am not able to understand that part.

Highlighted
Super User III

## Re: DAX function related Issue

Wow I have 2 fans now... Other is my 3 year old son

Actually FILTER function is an ITERATOR.... it creates a ROW context and not a FILTER context

thats why you have to use Calculate

Try my new Power BI game Cross the River

Announcements

#### Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Top Solution Authors
Top Kudoed Authors