How to use VALUES function with filters in DAX

[hemingt]

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 SELECTEDVALUE?

such as Column A, B

I want to get the VALUES(column A which column B=SELECTEDVALUE)

[v-lili6-msft · Accepted solution]

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]

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?

[hemingt]

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]

anyone who can help on this topic? Thank you very much!

if there is anythin unclear, please let me know.