Power BI RANKX Function 📊 #shortsvideo #shorts #shorstviral

The RANKX function ranks a number in a list for each row within a table.

SYNTAX - RANKX(Table, Expression, [Value], [Order], [Ties])

📝 Parameters
Table: 📋 A table or a DAX expression returning a table.
Expression: 🧮 A scalar expression evaluated for each row.
[Value] (Optional): 🔢 Scalar value to rank. Defaults to the current row's value.
[Order] (Optional): 📈 Ranking order - ASC (ascending) or DESC (descending).
[Ties] (Optional):
SKIP (default): ⏭️ Skips ranks after ties.
DENSE: ➕ Assigns the next rank immediately after a tie.
💡 Note
If your "Total" row shows a rank of 1️⃣, exclude it from the ranking by combining IF and HASONEVALUE functions with RANKX.

This expression checks if there is only one value in the Product column before applying the rank, thus excluding the "Total" row from being ranked.

Using the RANKX function helps in analyzing data effectively by ranking values dynamically within your tables, providing valuable insights and making data comparison easier. 🚀