Forum Discussion
Use dax variable inside filter
I am trying to filter a table based on how another table is already filtered by building a variable and using it in the filter, but I seem to be doing something wrong. Here is a sample of the data I ...
I'm trying to optimize my DAX formula by using a variable inside a filter context. Has anyone successfully implemented this? I’m curious about the best practices and any tips you might have to share
lbendlin
Super User
Super UserRemember that a variable is materializing. Use it mainly if you want to re-use the result without impact from a filter context.