Forum Discussion

trishd1223's avatar
trishd1223
Frequent Visitor
3 years ago
Solved

How to use RANKX and exclude 0's

Hi - trying to rank #'s and it's including all 0's.  how do i exclude 0's from the ranking? 

 

 

Data Modeling
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi trishd1223 ,

     

    According to your description, you want to rank the values in $Chg column except 0, create a calculated column like this:

    Column =
IF (
    'Table'[Chg] = 0,
    BLANK (),
    RANKX ( FILTER ( 'Table', 'Table'[Chg] <> 0 ), 'Table'[Chg] )
)

    Result:

    Is this the result you expected? 

     

    Best Regards,
    Community Support Team _ kalyj

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi trishd1223 ,

     

    According to your description, you want to rank the values in $Chg column except 0, create a calculated column like this:

    Column =
IF (
    'Table'[Chg] = 0,
    BLANK (),
    RANKX ( FILTER ( 'Table', 'Table'[Chg] <> 0 ), 'Table'[Chg] )
)

    Result:

    Is this the result you expected? 

     

    Best Regards,
    Community Support Team _ kalyj