Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help With rank

I have a table Containing columns like   CustomerID,    DeliveryStatus                   DateRegistered   etc.... 1-123                  Late                       2010-01-01 1-123               ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi Anonymous 

    Just adjust the formula as below:

    Rank = RANKX(ALLSELECTED('Table'[CustomerID]),CALCULATE(COUNT('Table'[DeliveryStatus]),'Table'[DeliveryStatus]="Late"))

    Result:

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi, Anonymous 

For rankx funtion, it usually involves row context in the visual.

If possible, please share a simple sample pbix file for us have a test, that will be great help.

 

Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I see. It works correct as long as I don't add the "Customer Name"   that is in another table (that links on the customer id)