Code to find on statement true and another false

Anonymous — Fri, 01 Jul 2022 04:59:27 GMT

I want to create a code that can detect one statement true but the other is false and not sure how to write it in DAX. I would like it to flag in a new colomn where address no. is the same but the post code is not the same.

For example

Current Data
Address No.	Post Code
13334	124
13334	123
54899	124
56465	111
46546	234
46546	234

Result
Address No.	Post Code	Test
13334	124	Yes
13334	123	Yes
54899	124	No
56465	111	No
46546	234	No
46546	234	No
13334	111	Yes

Re: Code to find on statement true and another false

amitchandak — Fri, 01 Jul 2022 08:34:36 GMT

Anonymous , Create a new column like

New column =
var _cnt = calculate(distinctcount(Table[ Post Code]), filter(Table,[Address No] = earlier(Table[Address No])))
return
if(_cnt >1 , "Yes", "No")

topic Code to find on statement true and another false in DAX Commands and Tips

Code to find on statement true and another false

Re: Code to find on statement true and another false