Dealing with Blanks on Drill Through

[Anonymous]

Hello 

I have set up a drill through to go from one table from another. The Drill through is using 2 common columns from a table. E.g. Forename and Surname

The issue I am facing is my data doesn't always have both columns populated. So when I am drill thorughing on forename "John", the second table is filtering for a Forname of "John" and a Surname of Blank.  Which isn't showing any data. 

What I want the second table to do is filter on Forename of John, and not filter on anything from the surname column so it shows all record with a forename of "John" regardless of their suname. 

Hope that makes sense and any help woud be much appreciated. 

[Anonymous]

Hi @Anonymous ,

What does your raw data look like? How did you set up the drill through? Which field was applied to the Drill through option? And could you please provide your expected result with detailed explanation and special examples in order to give you a suitable solution? Thank you.

Set up drillthrough in Power BI reports

Best Regards

[Anonymous]

Any Help?