cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jabbajuice08
Frequent Visitor

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

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) : 

 

jabbajuice08_1-1669671554065.png

 

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: 

 

jabbajuice08_2-1669671662569.png

 

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? 

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

Hi @jabbajuice08 ,

 

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

vjianbolimsft_0-1669690452870.png

Please try:

First, duplicate the source table

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

vjianbolimsft_2-1669690655094.png

apply the measure to the visual's filter:

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

vjianbolimsft_3-1669690712135.png

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

vjianbolimsft_4-1669690812907.png

Final output:

vjianbolimsft_5-1669691419671.gif

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.

View solution in original post

2 REPLIES 2
jabbajuice08
Frequent Visitor

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
Community Support
Community Support

Hi @jabbajuice08 ,

 

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

vjianbolimsft_0-1669690452870.png

Please try:

First, duplicate the source table

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

vjianbolimsft_2-1669690655094.png

apply the measure to the visual's filter:

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

vjianbolimsft_3-1669690712135.png

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

vjianbolimsft_4-1669690812907.png

Final output:

vjianbolimsft_5-1669691419671.gif

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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.