Count Function Issue When Adding Additional Column

[MarkB30308]

I have a table where I am trying to identify duplicate values based on a concatentation and then have the duplicate records shown to me.  In the example below, we have the LANE ID (CONCATENTATION) and the count of that lane ID.   However, once the Unique ID column is added, it displays LANE ID Count of 1 for each record even though there are clearly two LANE ID records (picture 2).  I had this tool working until this morning when I refreshed my data source and then accidentally saved over my previous version.  Does anyone know what I am missing that is causing it to not count properly?

 (When summarized by LANE ID w/ count of LANE ID and filtered on values greater than 1.  I identify all duplicates however, when adding the Unique Identifier as shown below, I receive a blank document.   As I mentioned, this was working as of this morning and now I am unable to reproduce the same results after refreshing my data). 

As seen below, after the filter of one is removed, the data is displayed but you can clearly see where there are duplicate lane ID's. 

 

Any help is greatly appreciated. 

[v-chuncz-msft · Accepted solution]

@MarkB30308,

The [RATE_GEO_GID] is different. You may add a measure as shown below.

Measure =
CALCULATE (
    COUNT ( Table1[RATE_GEO_GID] ),
    ALLEXCEPT ( Table1, Table1[LANE ID] )
)

[MarkB30308]

Thank you so much!  This worked perfectly!