Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @ajinkya1907
How about this one?
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] )
Hi @ajinkya1907
How about this one?
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] )
Well That works just fine. @Zubair_Muhammad, I am your fan buddy.
Could you please explain why calculate function made the difference? I am not able to understand that part.
Hi @ajinkya1907
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |