what am i doing wrong with sumx

[cristianj]

i use this script and it works : 

now i am trying to use a sumx function

TestTopN = var DataCurent=date(2023,5,2)

Var ModelCurent="iPhone 11"

var ShapeCurent="EXCELENT"

var StorageCurent="128 GB"

Var TabTemp=SELECTCOLUMNS(filter(VanzareZilnica,VanzareZilnica[Date]>=DataCurent-30&&VanzareZilnica[Date]<=DataCurent-1&&VanzareZilnica[model]=ModelCurent&&VanzareZilnica[shape]=ShapeCurent&&VanzareZilnica[storage]=StorageCurent),"Model",VanzareZilnica[model],"Storage",VanzareZilnica[storage],"Shape",VanzareZilnica[shape],"Data",VanzareZilnica[Date].[Date],"Vanz Zilnica",VanzareZilnica[Vanz Zilnica])

var tabtest=TOPN(5,TabTemp,[Vanz Zilnica],DESC)

var tabtest2=calculate(SUMX(tabtest,[Vanz Zilnica]))

return tabtest2

it gave me an error

thank you

[amitchandak · Accepted solution]

@cristianj , try like a measure

TestTopN =
VAR DataCurent =
DATE ( 2023, 5, 2 )
VAR ModelCurent = "iPhone 11"
VAR ShapeCurent = "EXCELENT"
VAR StorageCurent = "128 GB"
VAR TabTemp =
SELECTCOLUMNS (
FILTER (
VanzareZilnica,
VanzareZilnica[Date] >= DataCurent - 30
&& VanzareZilnica[Date] <= DataCurent - 1
&& VanzareZilnica[model] = ModelCurent
&& VanzareZilnica[shape] = ShapeCurent
&& VanzareZilnica[storage] = StorageCurent
),
"Model", VanzareZilnica[model],
"Storage", VanzareZilnica[storage],
"Shape", VanzareZilnica[shape],
"Data", VanzareZilnica[Date].[Date],
"Vanz Zilnica", VanzareZilnica[Vanz Zilnica]
)
VAR tabtest2 =
CALCULATE ( SUMX ( KEEPFILTERS(TOPN ( 5, TabTemp, [Vanz Zilnica], DESC )), [Vanz Zilnica] ) )
RETURN
tabtest2