A developer wants to display the top 5 products by sales AND an ‘Others’ category grouping the remaining products. Which technique achieves this in Power BI?

Question

Power BI — Hard

A developer wants to display the top 5 products by sales AND an ‘Others’ category grouping the remaining products. Which technique achieves this in Power BI?

Accepted Answer

To achieve the desired grouping, a calculated column using IF(RANKX(...) <= 5, Product, 'Others') is necessary. This method correctly categorizes products. Options A and B are incorrect as they don't provide a unified view, while D is close but lacks the calculated column's flexibility.