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

I realize that my date measure are on another table that InvcDtl. It's the reason why the rank took all my customer. But my date table are linked with my InvcDtl table? Why the Date filter won't apply?

  • 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