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
vbourbeauResolver II
Resolver IIOK 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.
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi 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