Some values are duplicated in the table

[Eliska1]

Hi all,

I created a measure that gives me a count of values in a specific column, but when I add it to the table, each of the locations the measure is relevant to is duplicated.

How do I fix this so I see the overall count for the location instead of two values?

[Eliska1 · Accepted solution]

Hi all, it seems that the issue has resolved itself when I added a new dataset! Thanks for your help.

[jdbuchanan71]

@Eliska1 I am betting there are trailing spaces on some of the values in your Location column and that is why PowerBI thinks they are different lines.