Forum Discussion

kaweckil's avatar
kaweckil
New Member
2 years ago

Dynamically query the dataset

Hi,

 

I want to query a details page to export to csv.

How would i dynamically update the filter condition of my table? I've used SELECTEDVALUE() but no luck.

 

Thanks!

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    SELECTEDVALUE needs a filter context which doesn't exist when you export. You need to bring your own filters when you run the DAX query against the semantic model.

     

    what's a "details page" ?

    • kaweckil's avatar
      kaweckil
      New Member
      2 years ago

      OK - do you mean that the filter value must be hard coded? The link applies filters on the page from the URL so I was trying to get the those values to use in the dax query

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        I didn't say hardcoded. I said you need to bring your own filters when you construct the DAX query.