Forum Discussion

hemingt's avatar
hemingt
Helper V
6 years ago
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...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

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

  • hemingt's avatar
    hemingt
    Helper V
    6 years ago

    Thank you v-lili6-msft 

    I use the below to solve my problem

    CALCULATETABLE(VALUES(Tasks[Week]), FILTER(Tasks, Tasks[Fix Version] = SELECTEDVALUE(Tasks[Fix Version])))
  • hemingt's avatar
    hemingt
    Helper V
    6 years ago

    it seems that my solution did not work.

    CALCULATETABLE(VALUES(Tasks[Week]), FILTER(Tasks, Tasks[Fix Version] = SELECTEDVALUE(Tasks[Fix Version])))

     

    I have a table Tasks, and want to firstly apply the filter "Tasks[Fix Version] = SELECTEDVALUE(Tasks[Fix Version])"

    then get the unique value of the column Week by using VALUES.

     

    Do you know how to do?