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

10 Replies

  • 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

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

      Its a theoretical question. If you dont understand it, you probably cant help me, but thanks anyway

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

    What is the user experience? Drilling through from what types of visual? 

    With the keep all filters, most drill through scenarios work. The extra detail was useful, but need more.

     

     

    I agree with TomMartens, based on the info given, seems unlikely, but I'm curious to hear the use case and more detail. 

     

    For now, I need to get back to my day job.

     

  • mdHuz's avatar
    mdHuz
    Frequent Visitor
    1 year ago

    Has any solution being found for this scenario?