The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |