Forum Discussion
Solved
Remove rows based on duplicate value in column
Looking for a DAX formula to remove rows based on duplicate serial numbers. I currently have a data table with multiple rows. Some of the rows have the same serial number. I would like to count th...
Oops!
Got it,
Tt_SerialNumber_Replace = CALCULATE(
DISTINCTCOUNT(Planilha1[serial Number]);
filter(ALL(Planilha1);Planilha1[Part Replace]=1))Please try and test using it. And please mark the right answer as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
Best Regards,
Rfranca
Sample data below, looking for the dax formula so the rows that are counted or summed equals 5. Only count the serial number if part replace equals 1 and only count the serial number one time.
| serial Number | Part Replace |
| 1 | 1 |
| 1 | 1 |
| 1 | 0 |
| 1 | 1 |
| 2 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 0 |
| 4 | 0 |
| 4 | 1 |
| 5 | 1 |
| 6 | 0 |
| 6 | 0 |
Measure = CALCULATE(DISTINCTCOUNT('Table'[serial Number]),FILTER('Table','Table'[Part Replace]=1))