Forum Discussion
Solved
New to PowerBi - removing duplicate data within a column
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?
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-duplicatesIf I answered your question, please mark my post as solution, Appreciate your Kudos 👍
2 Replies
- Idrissshatila
Super User
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-duplicatesIf I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you 😁
