TopN Product with Others and ranked by price unit

[Filippomonti]

HI all, 

i have this kind of dataset of product, quantity, revenue and price unit:

I want to create a report where i can choose, through a slicer i already created, the top N product to show based on price unit and all the other products excluded in the generic "others".

I already created a new table with the UNION function and I have this table

So i want this kind of output where i show only the top n product, others and their data using Price unit as Driver

I know how to do this using quantity and revenue as drivers but i can't figure it out when it comes to price unit as driver.

Is there a way I can do this report?

Thank you very much for your help!

Filippo

[Filippomonti]

Thanks for the reply but the problem is to calculate the price unit of others because in my report (created with the link @lbendlin sent) the measures calculate the sum of revenue using that as driver. I want to use Price unit as driver so it sums up the revenue and quantity of others product with price unit that is out of the top n

[Ashish_Mathur · Accepted solution]

Hi,

I have solved a similar question in the attached file.  Hope this helps.

[lbendlin]

Looks like you already did most of the work.  Where are you stuck?

Filtering the top products alongside the other products in Power BI - SQLBI