Hi im building the Best Bowling figures expression for my app where i need to get the highest wickets taken with the least runs for those wickets.
for ex: in T20 if i have 5 wkts for 35 runs and 5 wkts for 40 runs then the formula should pick 5 wkts for 35 runs as the Best Bowling figures.
getting the MAX wickets is easy but what im not getting is the corresponding lowest Runs Given for that max Wickets Taken
Wickets and Runs Given are separate columns as i need them for other calculations.
im trying the following expression:
=Min(T20[Runs Leaked]).MAX(T20[Wickets Taken])
it doesn’t return the corresponding lowest runs for the MAX Wickets Taken, but it returns the lowest runs of all.
how can i correct this? thanks