Forum Discussion

vbourbeau's avatar
vbourbeau
Icon for Resolver II rankResolver II
7 years ago
Solved

Rankx return empty value

Hi,   I have a matrix where I want to return the rank of my customer by total sales for a specific period. I put this DAX rank = rankx(ALLSELECTED(InvcDtl[Customer Name]);calculate(sum(InvcDtl[T...
Need Help
vbourbeau's avatar
vbourbeau
Icon for Resolver II rankResolver II
7 years ago

Hi,

 

With my true data when I apply the filter the matrix give me this error:

there's not enough memory to complete this operation

I restart my computer and nothing.

Without the filter the matrix run in a sec.

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    7 years ago

     

    rank = RANKX ( ALLSELECTED ( Feuil1[Part] ) , CALCULATE ( SUM ( Line[amount] ) ) )
    • vbourbeau's avatar
      vbourbeau
      Icon for Resolver II rankResolver II
      7 years ago

      I want to rank the client, as we see in my example.pbix