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                   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.
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

4 Replies

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