how to get flag value

Hi Anonymous ,

Here is your solution in a calculated column. this is the simple one. please let me know if you really wanna do this in a measure.

Anonymous 

Calculated Column:

Flag = 
IF(
tblB[ID] IN DISTINCT(tblA[ID]),
1,
0
)

This creates a new column in tblB with the same result.

💌 If this helped, a Kudos 👍 or Solution mark ✔️ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

Thanks for the reply from Rupak_bi and Kedar_Pande, please allow me to provide another insight.
Hi Anonymous ,

You can use the following DAX to create a table that meets your needs.

Table = 
ADDCOLUMNS (
    TableB,
    "Flag",
        IF (
            ISBLANK ( LOOKUPVALUE ( TableA[tblAID], TableA[tblAID], TableB[tblBID] ) ),
            0,
            1
        )
)

Best Regards,
Dengliang Li

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