Forum Discussion
Solved
How to use VALUES function with filters in DAX
Hello, Do you know how to use the VALUES function with filter? I want to get one unique column by VALUES function, and this column also should base on another column condition according to the SELE...
hi, hemingt
For your case, I think you need to use IN operator in the formula.
for example:
FILTER( TBALE, SELECTEDVALUE( column B) IN VALUES(column B))
Here is a blog for you refer to:
https://www.sqlbi.com/articles/the-in-operator-in-dax/
If you still have problem, please share some sample data and your expected output.
Best Regards,
Lin
anyone who can help on this topic? Thank you very much!
if there is anythin unclear, please let me know.