Why do I see duplicate entries in my matrix visual?

[Rnaval]

Any idea why I am seeing duplicate entries in my matrix visual?

[Ashish_Mathur]

Hi,

Looks like a problem of relationships between tables.

[johnbasha33 · Accepted solution]

HI @Rnaval 

Hidden Differences in Key Columns

Even though two rows look identical in the matrix, their underlying values may differ slightly — e.g.:

• Extra spaces ("Product " vs "Product")

• Case differences ("ABC" vs "abc")

• Different data types (e.g., string "123" vs number 123)

✅ Fix: Use TRIM(), UPPER(), or VALUE() functions in Power Query or DAX to clean and standardize your data.

Granularity Mismatch

You may be using fields with higher granularity than shown. For example:

• You added a Date field but only show Year in the matrix

• Behind the scenes, multiple records have the same year but different dates — they collapse visually but still produce multiple rows

✅ Fix:

• Use aggregated fields or group in your data model

• Or create a calculated column like Year = YEAR([Date]) and use that instead
  
  

  Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Rnaval]

What if I wanted to see a single row for a unique IP address only and disregard all other columns?

[kyle_mueller]

As a test:  If you add just the IP address field to the matrix visual and nothing else, do you still see duplicates?  

Duplication can sometimes happen as a result of adding in additional fields to your matrix that are at a different level of granularity than the IP address.  As a good example, if we think about geographical data, you could have columns for "state" and "city" data.  Adding just the "state" field would show you a unique list of states, but as soon as we add the "city" field into that matrix as well, we would see each state repeated multiple times, once for each city within the state.