Help With rank

[Anonymous]

I have a table Containing columns like

CustomerID,    DeliveryStatus                   DateRegistered   etc....

1-123                  Late                       2010-01-01

1-123                   OK                        2014-01-01

1-123                   Late                       2015-01-01

20-2021               Late                       2011-12-01

What I want to do is create a messure for  rank  Customer based on existens of late delivery  (IE count of rows with late delivery)

I Tried something like 

= RANKX(ALLSELECTED(Table[CustomerID]); :CALCULATE(COUNTX(Table;Table[DeliveryStatus]);FILTER(Table;Table[DeliveryStatus]="Late"))   But   can't get it to work. What Have I missed.

[v-lili6-msft · Accepted solution]

hi @Anonymous 

Just adjust the formula as below:

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

Result:

Regards,

Lin

[Anonymous]

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]

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]

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)