Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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] ) )
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] ) )
Thank you so much! This worked perfectly!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |