Usage of SUMX and its syntax

[Anonymous]

Can anyone please explain the below DAX? When SUMX is supposed to have "Table" as its first argument, below code has column expression as its first parameter. Is it the right usage when the right syntax is supposed to be "Table" as yth

[sales of the top 10 sold products]
= SUMX(
TOPN(
10,
SUMMARIZE(Product, [ProductKey], "TotalSales",
SUMX(RELATED(InternetSales_USD[SalesAmount_USD]),InternetSales_USD[SalesAmount_USD]) +
SUMX(RELATED(ResellerSales_USD[SalesAmount_USD]), ResellerSales_USD[SalesAmount_USD]))
)
)

[v-shex-msft]

HI @Anonymous,

Perhaps you can take a look at the following blog, it mentions the usage of 'use related function work as filters':
DAX Filter - RELATED function 

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , I doubt you need related .

Create two measures like these

TotalSales = InternetSales_USD[SalesAmount_USD] +ResellerSales_USD[SalesAmount_USD]

Top 10 City Rank = CALCULATE([TotalSales],TOPN(10,all(Product[ProductKey]),[TotalSales],DESC),VALUES(Product[ProductKey]))

For TOPN Refer : https://www.youtube.com/watch?v=QIVEFp-QiOk

in case sumx related will come at column name

example

SUMX(Product,RELATED(InternetSales_USD[SalesAmount_USD]))

[AllisonKennedy]

@Anonymous  Is this your data or sample file? SUMX first argument is a table or table expression, so TOPN returns a table, in your case with 10 rows. 

[Anonymous]

Thanks for responding.

But "Related" in the SUMX expression returns a scalar value, which is not a table/ table expression.. when SUMX is supposed to have TABLE of Values as its first argument. Hope you understand my point.