How to filter table values of column1 based on column2 value

[montibellin]

Hi Guys,

I've a tableA with two columns where column1 values can occur in column2.

I need to create in DAX a new table with all rows of tableA  if the column1 has value that if present in column2
the picture below can explain my goal

[VahidDM · Accepted solution]

Hi @montibellin 

Create your new table with this DAX expression:

Table 2 = 
Var _C2 = VALUES('Table'[Column2])
return
CALCULATETABLE('Table','Table'[Column1] in _C2)

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube