Forum Discussion

Eliska1's avatar
Eliska1
New Member
4 years ago
Solved

Some values are duplicated in the table

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?

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

2 Replies

  • 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.

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