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.

       

      • 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