topic Re: How do I validate that an ID exists in another table? in DAX Commands and Tips

How do I validate that an ID exists in another table?

eryan123 — Thu, 09 Sep 2021 19:58:05 GMT

Hello All,

I have a table that has multiple ID in one table. For example, one table will have the ID multiple times with different data.

ID	Data_1	Data_2
1
1
2
2
2

The other table is much smaller and only has the ID once.

ID	Data_3	Data_4
1
2
3
4
5

I would just like to return "Yes" if it does. "No" if it doesn't. I would like to do this with a calculated column so I have the ability to filter.

Thank you in advance!

Re: How do I validate that an ID exists in another table?

wdx223_Daniel — Fri, 10 Sep 2021 01:15:14 GMT

create a one to many relationship by ID

NewColumn=if(countrows(relatedtable(table1)),1,0)

Re: How do I validate that an ID exists in another table?

VahidDM — Fri, 10 Sep 2021 04:01:48 GMT

Hi eryan123

The wdx223_Daniel can cover your request with the relation.

You can also create a calculated column with this code in Unique Table:

validate = Var _Comm = LOOKUPVALUE('multiple ID'[ID],'multiple ID'[ID],'Unique ID'[ID]) return if(ISBLANK(_Comm),"No","Yes")

Output:

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

Appreciate your Kudos✌️!!