topic Re: how to get flag value in DAX Commands and Tips

how to get flag value

Anonymous — Thu, 28 Nov 2024 07:44:59 GMT

Hi Team,

I have table table A and table B ... see the below result .. how i can achieve on the based on DAX measuare.

Please check and provide an update

tblA 1,2,3,4,5
tblB 3,4,9,10

result
tblBID	Flag
3	1
4	1
9	0
10	0

Re: how to get flag value

Rupak_bi — Thu, 28 Nov 2024 08:49:50 GMT

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.

Re: how to get flag value

Kedar_Pande — Thu, 28 Nov 2024 09:33:03 GMT

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

Re: how to get flag value

Anonymous — Fri, 29 Nov 2024 07:30:43 GMT

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.