Drillthrough by a removed filter on a Specific Visual

[Sb00cheh]

Hi,

I've created a drillthrough for an employee details page. The drillthrough is using Name to provide the employee details which display typical fields (name, title, management level, business unit, department, etc.) However, I want to create a table within that drillthrough page that lists other employees that share the same title. Is this possible, as that table filters to name so it only results into the employees name and not their colleagues? I can bypass by doing another another drillthrough from the employee page, that yields the list of folks with the same titles, however, i'd really like it displayed on the employee page itself. Is there a way to bypass or write a measure to get it all displayed on a single drillthrough page?

For instance, is there a way to link a table from another page, or a DAX formula for a measure that can display all names that share the EEs title?

[Anonymous · Accepted solution]

Hi @Sb00cheh ,

Thanks for the reply from ToddChitt . The method ToddChitt provided was helpful, I have another method.

Make a copy of the original table, the reason for this is that if you use the original table on the drill through target page, the filtering effect will filter out the data, so you need to use a new table with the same data on the target page.

Create a measure that returns 1 when the title obtained after page 1 drill through is equal to the title of the new table.

MEASURE =
VAR _curTitle =
    SELECTEDVALUE ( 'EmployeeData'[Title] )
RETURN
    IF ( MAX ( 'EmployeeData (2)'[Title] ) = _curTitle, 1 )

When clicking on Alice's name drill through in page1, the visual effect of page2 is shown below:

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Sb00cheh]

Thanks! Worked like a charm!

[ToddChitt]

Not sure if this will work, but try creating a COPY of the employees table with a simple DAX formula:

Employees2 = Employees

Relate Emplyees2 to Employees on the Title field of each table. Make it a Many-to-Many relationship.

Now when you filter Employees by [Name], Power BI can traverse the relationship to Employees2 by matching anyone with the same Title. On your drillthrough page, add rows from Employee2. That should be the people that have the same Title as the filtered (drillthrough) employee.

Hope that helps.