Dax error message - Special flag is not allowed as an argument number 3 function RANKX

[PBI-Curious]

PBI Community Good Day!

I'm trying to create a dax measure that ranks the top 10 products by revenue_amount_usd

Need to solve for the error message below.

Much appreciated your time.

Thank you

[DallasBaba]

@PBI-Curious Let replace the VALUES function with SUMMARIZE to create a table that includes the 'product' column and the calculated 'TotalRevenue' column.

Top 10 Products by Revenue =
CONCATENATEX(
TOPN(
10,
SUMMARIZE(
'revenue_prelim_data',
'revenue_prelim_data'[product],
"TotalRevenue", CALCULATE(SUM('revenue_prelim_data'[revenue_amount_usd]))
),
[TotalRevenue], DESC
),
'revenue_prelim_data'[product],
",",
[TotalRevenue]
)

Please let me know if that works.

Thanks