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

Ok I do a example see the attachment.

 

the result give that

ClienD and ClientE don't have any sales in 2016 but the table show them?

 

If I remove my Rank measure the filter work ok.

 

I don't know how to add my pbix so I create a link. https://we.tl/t-f0OQ4nhFOm

 

 

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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

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

    Stil there,

    Can you send me your modify pbix

     

     

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

        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.