TOPN
TOPN (
3,
ADDCOLUMNS (
VALUES ( 'DimProduct'[FrenchProductName] ),
"@Sales Amount", [Total Sales]
),
[@Sales Amount],
DESC
)
ORDER BY [@Sales Amount] DESCCALCU
TOPN (
3,
ADDCOLUMNS (
VALUES ( 'DimProduct'[FrenchProductName] ),
"@Sales Amount", [Total Sales]
),
[@Sales Amount],
DESC
)
ORDER BY [@Sales Amount] DESCCALCU