Forum Discussion
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...
Hi vbourbeau ,
Maybe you could refer to below link about rank with hierarchy:
https://dataninjago.com/2017/12/11/dax-ranking-with-hierarchy-drill-down/
Regards,
Daniel He
Thank you
Do you know if it's my dax the problem, because if the date are in the same table as the invoice the problem don't occure? kind of relationship with both table?
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.
Look If I add a line in my matrix the rank lost is mind? See the pbix
link to te file https://we.tl/t-0gcXo9Adwq
- rank = RANKX ( ALLSELECTED ( Feuil1[Part] ) , CALCULATE ( SUM ( Line[amount] ) ) )
