Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am trying to use a date value from lookup as a variable for a filter but it doesn't seem to work. My DAX formula is shown as below:
Solved! Go to Solution.
You can't use SELECTEDVALUE when creating a table. Calculated tables are only calculated during data load or refresh, so they don't pay any attention to slicers or filters. If you need something to react dynamically to filters or slicers you need to do it in a measure.
You can't use SELECTEDVALUE when creating a table. Calculated tables are only calculated during data load or refresh, so they don't pay any attention to slicers or filters. If you need something to react dynamically to filters or slicers you need to do it in a measure.
Thank you @johnt75 for this info. Didn't know about this. I've managed to find a workaround by summarizing the data into another table and then apply the filters from there.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
69 | |
36 | |
21 | |
17 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
23 |