Forum Discussion
montibellin
Helper I
Helper IHow to filter table values of column1 based on column2 value
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
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!!
1 Reply
- VahidDM
Super User
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!!