Forum Discussion
vbourbeau
Resolver II
Resolver IIRankx 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
mussaenda
Community Champion
Community Champion
vbourbeauThank 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?
- vbourbeau
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.
- vbourbeau
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
- mussaendarank = RANKX ( ALLSELECTED ( Feuil1[Part] ) , CALCULATE ( SUM ( Line[amount] ) ) )