topic Re: Find unique value in two columns in DAX Commands and Tips

Find unique value in two columns

lpd82 — Tue, 14 Sep 2021 21:45:36 GMT

How do I check for two columns in a single table to see if they match? I need to create a column labeled "Check" to find ID where type A maches type B. TIA

ID	Type	Check
1	A	TRUE
2	A	TRUE
3	A	TRUE
4	A	TRUE
5	A	FALSE
6	A	FALSE
1	B	TRUE
2	B	TRUE
3	B	TRUE
4	B	TRUE

Re: Find unique value in two columns

amitchandak — Wed, 15 Sep 2021 03:34:28 GMT

lpd82 , Try a new column like

new column =
var _id = [ID]
var _Ty = [Type]
var _1 = countx(filter(Table, [ID] = _id && [Type] <> _ty),[ID)
return
if(isblank(_1), False(), True())

Re: Find unique value in two columns

lpd82 — Thu, 16 Sep 2021 14:03:58 GMT

Perfect! Thank you.