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
Hi vbourbeau ,
Based on my test, you could refer to below formula:
Rank = IF(CALCULATE(SUM(Line[amount]))=BLANK(),BLANK(),rankx(ALLSELECTED(Line[Client]),CALCULATE(SUM(Line[amount]))))
Result:
Regards,
Daniel He
Stil there,
Can you send me your modify pbix
OK but it's a table I need a Matrix to be able to drill down to another level.
The problem is there when we add more level.
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