Forum Discussion

vbourbeau's avatar
vbourbeau
Resolver 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
Resolver 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
Resolver 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
    Microsoft 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
      Resolver II
      7 years ago

      Stil there,

      Can you send me your modify pbix