Topn error

[Anonymous]

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.

[Anonymous]

Hi Raju,

Now its working Fine otherthen TOPN.

Test for TOP =

--Var _SV=SELECTEDVALUE(SBUTarget[SBUName])

Var _Tp=TOPN(3,ALLSELECTED('2425'[Customer Name]),'2425'[Achv_Val])

RETURN

CALCULATE('2425'[Achv_Val],

--FILTER('2425','2425'[Achv_Val]>10))

KEEPFILTERS(

FILTER('2425',

'2425'[Achv_Val]>10 && '2425'[SBUName]= "AI & ML" ||

 '2425'[Achv_Val]>5 && '2425'[SBUName]= "AV" ||

  '2425'[Achv_Val]>5 && '2425'[SBUName]= "Cloud" ||

   '2425'[Achv_Val]>5 && '2425'[SBUName]= "PCS" ||

    '2425'[Achv_Val]>5 && '2425'[SBUName]= "ECS" ||

     '2425'[Achv_Val]>5 && '2425'[SBUName]= "ESS" ||

      '2425'[Achv_Val]>5 && '2425'[SBUName]= "NWA" ||

       '2425'[Achv_Val]>5 && '2425'[SBUName]= "SCS" ||

       '2425'[Achv_Val]>5 && '2425'[SBUName]= "PWR" ||

        '2425'[Achv_Val]>5 && '2425'[SBUName]= "SERVICE" ||

        '2425'[Achv_Val]>5 && '2425'[SBUName]= "IMS" ||

        '2425'[Achv_Val]>5 && '2425'[SBUName]= "PS"

)

--'2425Rag'[SBUName]=_SV

))

[FreemanZ]

hi @Anonymous ,

TOPN returns a table, you can't CALCULATE a table directly. What do you plan to do with the top3 table?

[Anonymous]

Hi Freeman,

i am trying to get top 3 customer from the given table based on condition 

[rajendraongole1]

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]

Hi Raju,

Its says same error..

[rajendraongole1]

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]

No Luck Raju.

[rajendraongole1]

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]

Hi Raju,

TOPN function not filtering also total value calculattion showing wrong values

[FreemanZ]

hi @Anonymous ,

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

[Anonymous]

HI Freeman, 

Please find the sample data link..

https://drive.google.com/file/d/1dghNAIA1KugRnjBYfrLZ8Dj4h0bOh-4O/view?usp=drive_link