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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I can't get it to work:

 

NoOfRowsWithLate = CALCULATE(COUNT(Table[DeliveryStatus]);Table[DeliveryStatus]="Late")

And

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

 

 

I get this:

v-lili6-msft's avatar
v-lili6-msft
Community 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)