Forum Discussion

ajinkya1907

Helper II

8 years ago

Solved

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...

Need Help

Zubair_Muhammad

8 years ago

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] )