Top n Measure average

[japlesh]

While getting Top 10 average for a calculated measure, system gets hanged up.

Can anyone please help me out on this ASAP.

Thanks,

[japlesh]

i am tryied like following formula

AVERAGEX(TOPN(10,TABLE,COLUMN,DESC),COLUMN)

[Eric_Zhang]

@japlesh

The DAX looks normal, how many rows in your case? Application usually hangs due to memory,cpu, IO resouce storage.

[ankitpatira]

@japlesh How are you getting top 10 average. There are couple of ways you can do them.