Forum Discussion

PowerBITestingG's avatar
PowerBITestingG
Icon for Resolver I rankResolver I
4 years ago

Passing calculate filter to drillthrough

Anybody knows an actuall workaround or trick to enable this function?   Been looking through the forum but havent found a good answer   Thanks!
Need Help
KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

Hi PowerBITestingG, 

 

I'm not sure anyone can help you with the detail you've provided.

As Pragati11 was kindly trying to point out, if you take the time to provide some context, then you will likely get an answer to your question.

 

Don't mistake a request for more detail as an inability to understand or answer the question. She is more than qualified to help you.

 

Thanks.

 

  • PowerBITestingG's avatar
    PowerBITestingG
    Icon for Resolver I rankResolver I
    4 years ago

    Ill try to break it down

     

    I have a measure using Calculate and I want to pass that filter to a drillthrough page

     

    Like Measure = calculate([amount], Location[Country]="USA")

     

    I want to pass Country = USA to the drillthrough page

    • TomMartens's avatar
      TomMartens
      Icon for Super User rankSuper User
      4 years ago

      Hey PowerBITestingG ,

       

      at 1st glance you can't.

      If you take the time and create pbix file containing sample data, but still is reflecting your data model (tables, relationships, calculated columns, and measures), maybe one of the members of this community will spend some time to think more thoroughly about your requirement: passing a filter condition to a drillthrough page.


      Regards,

      Tom

    • hstance's avatar
      hstance
      Icon for Helper II rankHelper II
      4 years ago

      I have the same problem. Filters within a Calculate statement are not passed to the drill through visual. Your problem is clearly stated and the folks not able to understand are simply not reading. I think this is a product limitation myself.