Find the minimum value of a measure

[aicha]

Dear all,

I have several KPI's, these are all computed columns based on the data. E.g. one of them is written like this 

extra time = sum(QUERY[extra time])/QUERY[Total time])

For my KPI's, I want to know which of the different kind of players used the least extra time. I tried using MINA or MIN, but those functions won't accept measures or formulas instead of columns. 

I hope you can help me

Kind regards,

Aicha

[v-easonf-msft]

Hi， @aicha 

Not fully sure what you want and there seems to be an extra parenthesis in your formula. 

extra time = sum(QUERY[extra time])/QUERY[Total time])

Can you provide more details for further investigation?

Best Regards,
Community Support Team _ Eason

[ryan_mayu]

@aicha 

could you pls provide the sample data and expected output?