Forum Discussion
Display only repeated number
Hi,
I want to create a column which ID's are repeted from column ID.
| Id | Type | Status |
| RADOC0010024 | RAD | Cancelled |
| RADOC0010024 | RAD | Cancelled |
| RADOC0010056 | RAD | Cancelled |
| RADOC0010063 | RAD | Cancelled |
| RADOC0010076 | RAD | Cancelled |
| RADOC0010079 | RAD | Cancelled |
| RADOC0010079 | RAD | Cancelled |
| RADOC0010079 | RAD | Cancelled |
| RADOC0010090 | RAD | Cancelled |
| RADOC0010111 | RAD | Cancelled |
| RADOC0010141 | RAD | Cancelled |
| RADOC0010144 | RAD | Cancelled |
| RADOC0010144 | RAD | Cancelled |
| RADOC0010179 | RAD | Cancelled |
| RADOC0010211 | RAD | Cancelled |
| RADOC0010211 | RAD | Cancelled |
| RADOC0010211 | RAD | Cancelled |
| RADOC0010281 | RAD | Cancelled |
| RADOC0010282 | RAD | Cancelled |
| RADOC0010284 | RAD | Cancelled |
| RADOC0010284 | RAD | Cancelled |
Thanks !
Hi Anonymous ,
Create a calculated column on original table.
Column = CALCULATE(COUNT('Table'[Id]),ALLEXCEPT('Table','Table'[Id]))Then create a new table and filter out the records which count <=1.
Table 2 = DISTINCT(SELECTCOLUMNS(FILTER('Table','Table'[Column]>1),"id",'Table'[Id]))Best Regards,
Jay
8 Replies
Anonymous , You might have create a table
distinct(Table[Id])
Hi Anonymous
You can refer to this link below
https://community.powerbi.com/t5/Desktop/Identify-duplicates-and-show-up-records/td-p/210061
https://community.powerbi.com/t5/Desktop/Only-Show-Duplicates/td-p/385062
Kudo me if this is the solution.
Hi Anonymous
Download this PBIX file with the following solutions
This works to create a Calculated Column
Count Dup = Var ids = [Id] RETURN CALCULATE( COUNTROWS('Table'), ALL('Table'), 'Table'[Id] = ids )or you can do it in Power Query. Group By ID and then choose Count as the aggregation.
With both methods just filter out the count's less than 2.
Regards
Phil
Hi Anonymous ,
Create a calculated column on original table.
Column = CALCULATE(COUNT('Table'[Id]),ALLEXCEPT('Table','Table'[Id]))Then create a new table and filter out the records which count <=1.
Table 2 = DISTINCT(SELECTCOLUMNS(FILTER('Table','Table'[Column]>1),"id",'Table'[Id]))Best Regards,
Jay
