Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

ricardocamargos

 

Veing a less sophistocated user and a bit of a newb, I used the following statement:

 

Column = CONTAINS(Table2, Table2[Value], Table1[Value])

 

This creates a True/Flase value.  I change the value to text, and wrote an if statment that returns a vaule of Sold or Available.  Not ideal - but functional.

 

What would you recommend at the easiest way to apply a DAX statement that returns a desired value i.e. Sold or Available, when an ID matches or not from two tables?

 

Thanks.

ricardocamargos's avatar
ricardocamargos
Continued Contributor
8 years ago

Anonymous,

 

You can create a measure using the EXCEPT function, passing que ID`s. 

Sold = VAR tbl1 = SELECTCOLUMNS(TABLE_1, "ID")

VAR tbl2 = SELECTCOLUMNS(TABLE_2, "ID")

VAR tbl = EXCEPT(tbl1; tbl2)

RETURN

    COUNTX(tbl; ID)

 

Using this measure in a table you can visualize if it`s available or not, it will return 0 or non 0;

 

Thanks,

 

Ricardo