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 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.

 

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    Hi Anonymous -pls use below measure

     

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Raju,

      TOPN function not filtering also total value calculattion showing wrong values

       

       

      • FreemanZ's avatar
        FreemanZ
        Super User
        1 year ago

        hi Anonymous ,

         

        this shall already work. could you paste a link for your sample file?