Forum Discussion

Anonymous_226's avatar
Anonymous_226
Frequent Visitor
3 years ago
Solved

Comparing mutliples tables and returing unique values

Hi,   I have a requirement for the following to be done in DAX. I cannot create and additonal columns as I am connected with direct query to a dataset.   I have a scenario with 2 seperate tables ...
"DAX"
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous_226 

     

    You can try the following methods.
    New Table:

    Table = FILTER('Table A',[Fruit]<>"Kiwi")

    Table B:

    Measure = 
Var _table=EXCEPT(VALUES('Table'[Number]),VALUES('Table B'[Number]))
Return
IF(SELECTEDVALUE('Table'[Number]) in _table,1,0)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous_226 

 

You can try the following methods.
New Table:

Table = FILTER('Table A',[Fruit]<>"Kiwi")

Table B:

Measure = 
Var _table=EXCEPT(VALUES('Table'[Number]),VALUES('Table B'[Number]))
Return
IF(SELECTEDVALUE('Table'[Number]) in _table,1,0)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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