Forum Discussion

japlesh's avatar
japlesh
Frequent Visitor
9 years ago

Top n Measure average

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

 

Can anyone please help me out on this ASAP.

 

Thanks,

 

3 Replies

  • japlesh's avatar
    japlesh
    Frequent Visitor
    9 years ago

    i am tryied like following formula

     

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

     

    • Eric_Zhang's avatar
      Eric_Zhang
      Microsoft Employee
      9 years ago

      japlesh

       

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