DAX help

[Anonymous]

Hi,

I have two tables, one contain master table of ID (Table 1) and another table (Table 2) contains details of fact including ID.

Now I want to cross check whether ID from table 1 are present in table 2 or not. There is no join between two tables. I want to create a column that give whether it is exist in table 2 or not. My report is ID from table 1 and other columns from table 2. so that I will have all ID's from table 1 and will not miss any records if it is not present in table 2.

any workaround pls.

[Mikelytics · Accepted solution]

Hi @Anonymous 

You can solve this with LOOKUPVALUE(). Please find the example below

I have to table (Product and Customer). TRhey are not connected. Product ahs a ID column 1-6 and customer has an ID column 1-5.

Product Table

Customer Table

Now I created in the product table the following calculated column:

LookUp ID= 
var varLookUpValue = LOOKUPVALUE(Dim_Customer[PK_CustomerID],Dim_Customer[PK_CustomerID],[PK_ProductID])
RETURN
IF(NOT ISBLANK(varLookUpValue),1,0)

Result

Best regards

Michael

-----------------------------------------------------

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

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.