Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Topn error

Hi, Can Anyone help, Why my TOPN not filting the value, Its showing below error  The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.    
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi Anonymous - can you try below measure

Test for TOP =
TOPN(3,
FILTER('2425', '2425'[SBUName]="AI & ML"),
'2425'[ValuesinLakhs],
DESC
)

 

Hope it works

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Raju,

    Its says same error..

     

    • rajendraongole1's avatar
      rajendraongole1
      Super User
      1 year ago

      Hi Anonymous - can you try below updated with sumx

       

      Test for TOP =
      TOPN(
      3,
      FILTER('2425', '2425'[SBUName] = "AI & ML"),
      SUMX('2425', '2425'[ValuesinLakhs]),
      DESC
      )

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        No Luck Raju.