🔥 3-day streak
Microsoft Power BI Data Analyst142 / 205
Question 142 of 205

You are building a Power BI report on a star schema with a Sales fact table and a Product dimension. Business users want a table visual showing each product alongside its sales rank, where the product with the highest Total Sales is ranked 1. The ranking must recalculate dynamically as slicers (such as Region and Year) are applied. Which DAX measure should you create?

Reviewed for accuracy · Report an issueNext question