Help with the measure optimization - the most common price

[mic_rys]

Hi,

If anybody has a idea how to optimize below measure? I need to find the most common price. It works but very slow 😕 

Thanks a lot!

MostCommonPrice =
var prices = values(Details[Price])
var visitsnumber = calculate(DISTINCTCOUNT(Visitid), filter(Details, Details[Price] <> BLANK()))
return
CALCULATE(max(Details[Price]),
TOPN(1, ALL(Details[Price]),[visitsnumber]),
prices )

[VahidDM]

HI @mic_rys 

Can you sahre a sample of your data and the result you are looking for:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!