Any idea to calculate this data ?

[amarada]

I need to calculate the next data: the maximun value from a calculate measure / average form the reste values except the maximun. That is I have two columns: one of them is the city and the other is the sales conversion rate (average format) and I need to calculate the daily average dispersion of this way:

(maximun value of sales conversion rate/(average of the rest values-except the masimun value-)-1).

Any idea? Thank you very much and sorry for my english

[vanessafvg]

have no idea if this could work but give it a bash

@amarada

conversion =
var maxconversion = max(table[conversionrate])
var otheraverage = calculate (average(table[conversionrate]), filter(table[conversionrate]] < maxconversion ))
return divide(maxconversion , otheraverage)

[amarada]

 Thank you very much, I`m going to try this formula today and then I'll tell you how it was...it looks good

[v-chuncz-msft]

@amarada,

Any progress, feel free to share with us.

[amarada]

Excuse me, but I've been indisposed these days. Finally, I could not apply the formula or maybe I did not do it right. I did the calculations before importing the data to Power BI. Thank you very much, I will continue trying to do it and it helps me a lot the clues that have given me. It is already a challenge for me.

[CheenuSing]

Could you please share some data and the exact output exxpected.

Cheers

CheenuSing