Top N and Others with relation to dimension table

[vhsn]

Hello!

About Top N and Others, I've successfully done it with various guide - https://goodly.co.in/top-n-and-others-power-bi/ as one of them..

However, my Product is in the form of Product ID and I have a dimension table for it - and I want to display the Product Name instead of the Product ID

Basically:

Table: Dim_Product

Product ID | Product Name

1 to many relationship with

Table: Sales Table

Product ID | Sales

Measure: Top N Sum Sales

My calculation relates to the 'Sales Table'[Product ID]

I assumed I could create a relationship between measure and the dimension table - but it seems that's not the case..

I feel like I'm missing something here, it should be relatively simple to do..?

[v-xinruzhu-msft · Accepted solution]

Hi @vhsn 

You can refer to the following solution.

You can use the topn() filter to the visual

Put the product name to the filter, then select filter type to topn

Then select the value by the measue(sumsales)

You can refer to the following link.

zebrabi.com

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rubayatyasmin]

Hi, @vhsn 

Here are some suggestions you want to follow,

1. Ensure there's a relationship between Dim_Product and Sales Table on Product ID.
2. Create your Top N measure based on sales in the Sales Table.
3. In your visualization (e.g., chart or table), use Product Name from Dim_Product for display, and your Top N measure for values.
4. Power BI will use the relationship to match Product Name with its respective sales and show the top N products by name.

You don't need a direct relationship with the measure and dimension table; the existing relationships between tables will enable this to work.