What is RankX?

RANKX is a DAX function used to calculate the rank of a given value in a column of data. It is commonly used in Power BI reports to determine the ranking of products, customers, countries, and other entities based on their performance metrics such as sales, revenue, or profit.

Here is a live example of using RANKX in Power BI:

e.g:

Suppose we have a sales data table with the following columns: "Product", "Sales Amount", "Date", and "Region". We want to create a report that shows the top 10 products by sales amount for a selected region and date range.

To do this, we can create a RankX measure that ranks the products based on their sales amount within the selected region and date range:

Ranking by Sales Amount =

RANKX(FILTER(Sales, Sales[Region] = SELECTEDVALUE(Region) && Sales[Date] >= SELECTEDVALUE(StartDate) && Sales[Date] <= SELECTEDVALUE(EndDate)), [Sales Amount])

In this example, the FILTER function is used to filter the sales data to only include the sales in the selected region and date range. The SELECTEDVALUE function is used to retrieve the selected region and date range from the slicers in the report. The RANKX function then calculates the rank of each product within the context of the filtered table.

We can then use this RankX measure in a table visual to show the top 10 products by sales amount for the selected region and date range. The table can also include additional columns such as product name, sales amount, and percentage of total sales.

This live example demonstrates how RANKX can be used to provide valuable insights into business performance by ranking and visualizing data based on selected criteria.