Forum Discussion

_google's avatar
_google
Icon for Helper I rankHelper I
8 years ago
Solved

3#DAX : FIND ROW NUMBER BASED ON CRITERIA

  Hi Experts   Reaching out again for the DAX formula to arrive at calcuated formula to find the row number based on Criteria. For example Attrribute is valid if the marked as "Yes" in the source ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    _google

     

    May be you can use this Column

     

    Column =
VAR myrank =
    RANKX (
        FILTER ( TableName, TableName[Is Valid] = "Yes" ),
        TableName[Attribute],
        ,
        ASC,
        DENSE
    )
RETURN
    IF ( TableName[Is Valid] = "Yes", myrank )

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Not understanding what you are going for here but I can say that you probably need to add an Index column in Power Query to your query.

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

_google

 

May be you can use this Column

 

Column =
VAR myrank =
    RANKX (
        FILTER ( TableName, TableName[Is Valid] = "Yes" ),
        TableName[Attribute],
        ,
        ASC,
        DENSE
    )
RETURN
    IF ( TableName[Is Valid] = "Yes", myrank )