New to PowerBi - removing duplicate data within a column

[Nakita76]

I am new to PowerBi and can't seem to find if this is possible or not. I have a column with names in it and it puts the name per row and some have multiple rows. But i want to count the individual names within that column - not the overall amount. How do i do this please?

[Idrissshatila · Accepted solution]

Hello @Nakita76 ,

You could keep it as it is and use this measure

Measure = DISTINCTCOUNT(Table[Name])

and it will help you count the distinct names in a column.

or you could remove the duplicated from the table in Power query, refer to this link
https://learn.microsoft.com/en-us/power-query/working-with-duplicates

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Nakita76]

Thank you 😁