Forum Discussion

94gjcb's avatar
94gjcb
Regular Visitor
3 years ago
Solved

Use all data from drillthrough table to populate new table

I have a 3 page power bi report. First page selects a profile that has a list of 1000 accounts.

Table layout

Column 1 = Customer Name

Column 2 = Customer Product

Column 3 = Customer Address

 

This drillthroughs to another page where I can cut down that 1000 account list to a smaller subsegment that has a specific product I want to focus on. 

 

Now that i have my table on my third page with just my list of say 150 accounts with the specific product, I want to then pull in all products that those accounts have. Idealy I want to use all of the account names from column 1 to filter back against the original 1000 record table and pull in all lines where that customer name is listed. 

 

Hopefully this makes sense and I can be pointed in the right direction!

1 Reply