Forum Discussion
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.
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
))