Drill-through "Complex filter applied" causing no data to appear?

[Aidenifyable]

Hello All, 

I have hit my head against the wall with this error occuring on a report I created that utilizes several drill-through pages to enhance the report. The reason that it is frustrating me, is that the error seems to be selective, it only occurs on two of the three drill-throughs I am using and I cannot identify what is unique regarding the one that is working compared to the others that are not. But enough talk, hopefully with some visuals you can see what is happening.

So how it works, is that I have a drill-through that activates when a selection from the bar graph is clicked. A button appears which takes you to a another page with a table of data based on the filters. The error only happens when (Blank) is selected. See below:

These are the filters that it shows that get pulled over from the source page. Once I delete the "State from Source visual" on the drill-through filter pane, the data on the table appears as I would expect it to??? 

To recap, one of my drill-through pages works exactly as expected with no problems showing the blank values and I have tried to rule out everything that makes its data different but they are all columns from tables and all are using the same measure in the visual? Consequently, when am using the drill-through page that does work, neither of these "Complex filter applied" or "From Source Visual" boxes do not appear, it is only on the two reports that fail to pull in data for blanks on these pages?

Please help if you know why these messages appear as I cannot find any documentation that can explain what they mean.

[Aidenifyable · Accepted solution]

Thank you for your reply,

So I was able to solve the issue as there were two underlying problems with logic that I had written within the Dax. But primarily what happened was that I had a filter on the visual that was removing values with "0" and my DAX measure was turing (Blank) values into "0". What happened was the (Blank) column would show up, but all the values were assigned "0" and thus when using the drill through, all the values were removed. I changed the filter on the visual and it started working!

Thank you again!

[v-tianyich-msft]

Hi @Aidenifyable ，

The “From Source Visual” box appears only when you have cross-filtering between visuals. Check if the cross-filtering behavior is consistent across your drill-through pages. If not, investigate any differences in the visuals or relationships.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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