Slicing down by matching value from one column to the same value in another column

[jabbajuice08]

So I have one dataset with multiple columns such as ID #, start/finish date, etc. My report is supposed to slice down the ID # column based on a certain condition (ID #'s that have 'MMM' in the string and those that don't). When you slice down the MMM tasks, it looks at the ID # column and also filters out any tasks that are NULL in the Link ID # column like such (There shouldn't be any duplicates for ID #'s in this report, these are all summary tasks) : 

However, when you click or drillthrough one of the task numbers (MMM10 for example), it should then pull up a seperate report that looks at the Link ID # that matches the ID # like such: 

However, since I'm already filtering out Link ID #'s that aren't null, my second report table will not slice down correctly. Basically, the first report should just look at summary tasks for each distinct MMM task and when you click on each MMM task, it matches it to the corresponding, multiple tasks that look at the Link ID # that matches. How do I go about doing this properly? 

[jabbajuice08]

Thank you! This worked perfectly! I was also trying to make a column on the first page that has a count of the tasks that are pulled up with the drillthrough. How would I go about doing that since I'm using SELECTEDVALUE for the filter on the second page? @v-jianboli-msft 

[v-jianboli-msft · Accepted solution]

Hi @jabbajuice08 ,

Based on your description, I have created a simple sample:

Please try:

First, duplicate the source table

Then create a new table visual(use the new data):

apply the measure to the visual's filter:

Measure = IF(MAX('Table (2)'[Link ID #])=SELECTEDVALUE('Table'[ID #]),1,0)

Add source table's ID to the drill through field:

Final output:

Best Regards,

Jianbo Li

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