Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need help to rank non numeric data

 I have recently stated working on power bi and I'm struggling with this below mentioned scenario. your help will be appreciated 🙂   I wanted to rank some non character data in power bi using a meas...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago
    You can try this as a calculated COLUMN:

    Rank Dax = RANKX(FILTER(ALL('Table'), 'Table'[Product Id] = EARLIER('Table'[Product Id])), 'Table'[type],,ASC)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

getting error as parameter is not of correct type in earlier function

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago
are you doing as calculated column or measure? What is the exact error message you're getting?
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    AllisonKennedy I'm creating a measure to achive this and getting an error in EARLIER function as "Parameter is not of correct type"Please do let me know if there any other way to achieve this.

    • AllisonKennedy's avatar
      AllisonKennedy
      Icon for Community Champion rankCommunity Champion
      5 years ago
      To use EARLIER in this context it must be a calculated COLUMN. Not measure.

      If you want to use a measure it could possibly be done with the use of variables.
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        It worked :).
        Thanks