Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

RankX() function not available when creating a new calculated column with variable

Hi Daer Community,   I am trying to rank a column based on its count in anothercolumn. But the rankx() function is not available there. Top5 cases & Others = Var RankProductsByCaseCount = rankx...
DAX Command
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Which connection mode you are using?

    RANKX() function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

     

    Best Regards,

    Jay.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your reply. Yes, I am using Direct query connection mode.