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
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.