Filter top N products with a row for others

DAX DAX Calculations
1

I did Filter top N products with a row for others please refer to the following link:

My Question is if I need to pass any of the product names in the TopN table to another report for (Drill through) , how can I pass it to the column (Product Name) from Table (Products Name) to the Product table in the Drill through report?
Note:

  • I asked this question because sometimes the product name in products table is duplicated names but with Unique Identifier , I need to pass the Unique Identifier e.g. (Barcode) to the Drill through Report , In the youtube example it use the product name only without it’s Unique Identifier , How can I edit the Product Names table to Include (2) columns Uniqe Id , Product name?

I attached the pbix file with this post.

Looking forr answers.
C0120 - Filter top 3 products with a row for others using DAX in Power BI -EDNA.pbix (2.0 MB)

2

@MAAbdullah47 ,

This is an incredibly clever technique that you can use to ensure that your product names are unique, even if visually they look the same (through the use of nonprinting characters).

I hope this is helpful.

  • Brian
2 Likes
3

Thank you so much , I’ll check it and get back to you.

4

@MAAbdullah47 ,

FYI - I also adapted this technique using primarily Power Query. I typically use this version, rather than the DAX-only version:

  1. Group on the relevant name field in PQ (Group By) and add an All Rows aggregation called Data

  2. Add an index within each grouping with Custom Column:

=Table.AddIndexColumn([Data], “Index”, 1, 1)

  1. Add calculated column concatenating relevant field with (Index - 1) UNICHAR (8204) nonprinting character, e.g.,

Name No Duplicates =
Table[Name] & REPT( UNICHAR( 8204) ), Index - 1)

  • Brian
3 Likes
5

Hi @MAAbdullah47, did the response provided by @BrianJ help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

I hope that you are having a great experience using the Support Forum so far. Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!

1 Like
6

Sorry For late , soon I’ll test the solution

7

Hi @MAAbdullah47, we’ve noticed that no response has been received from you since the 21st of June. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

1 Like
8

Hi

I put like in the previous post , means the solution is work , shall I do another step more?

9

Hello @MAAbdullah47, can you clarify what you meant? Do you need further help with this inquiry?

1 Like
10

I put (favorite) on the solution is there any more action I should do ? how you want me to close the case as solved?

11

@MAAbdullah47 To mark the answer as SOLVED, click on the 3 dots on the area below the box

Screen Shot 2021-06-30 at 9.03.43 AM

Then check the SOLUTION box.

Hope this helps :wink:

12

I did please check.