Forum Discussion

Uzaring's avatar
Uzaring
Frequent Visitor
4 years ago

Help comparing two tables with dax

Hello! 

 

Just usign dax I need the following:

 

I created a virtual table in a measure from a table in my model

CALCULATETABLE( ALL(Table[column]), Table1[column] = "xx",Table2[column] = "xx")
 
I need to compare this table with another one generating a measure that flags with 1 or 0 if the value is in the virtual table.
 
Hopefully you can understand me
 
Thanks!!
Need Help

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, Uzaring 

    Not fully sure what you want. Can you explain bit more?
    Sample data for two tables  and expected result will make it easier for us to understand and solve your problem.

     

    Best Regards,
    Community Support Team _ Eason