Match Serial Numbers in Two Rows

[Anonymous]

I have two fields, "Card #" and "Serial Number."

Each "Card #" should have an exact match in the "Serial Number" field. However, due to some formating issues, I know there are some "Card #" that don't have an exact match in the "Serial Number" field.

Is there a measure to identify which numbers in the "Card #" field do not have a match in the "Serial Number" field?

[v-lid-msft]

Hi @Anonymous ,

If you are looking for a measure which can show all the card # which does not matched the series number dynamicelly, We can try to use the following measure to meet your requirement:

Not Matched Card # = CONCATENATEX(FILTER('Table','Table'[Card #] <> 'Table'[Serial Number]),[Card #],UNICHAR(10))

If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared？

Best regards,

[amitchandak]

Try

EXCEPT(distinct(table[Card#], distinct(table[SerialNo]))

refer https://docs.microsoft.com/en-us/dax/except-function-dax

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

If in the same table you can just use:

Column = IF('Table'[Card #] <> 'Table'[Serial Number], "Not Equal", "Equal")

[parry2k]

@Anonymous how does your data looks like? Are these in same table or different table? Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490