Goal: Rank products by Sales Amount.
Logic: For every product, count how many others have higher sales.
Ready...
💻 DAX Formula
-- Rank Products by Sales Amount
MEASURE Rank =
RANKX(
ALL( Products ), -- 1. Table to rank against
[Total Sales], -- 2. Expression to measure
, -- 3. Value (Optional)
DESC, -- 4. Order (High to Low)
Skip -- 5. Ties (Skip or Dense)
)