Forum Discussion

Aidenifyable's avatar
Aidenifyable
Frequent Visitor
2 years ago
Solved

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

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...
Need Help
  • Aidenifyable's avatar
    Aidenifyable
    2 years ago

    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!

Aidenifyable's avatar
Aidenifyable
Frequent Visitor
2 years ago

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!