The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
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" ?
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
I didn't say hardcoded. I said you need to bring your own filters when you construct the DAX query.