How do I remove duplicates on a more permanent basis?

[DouglasWatkins]

I have a data set that looks like the below data.  I created a graph based on the Time column.  I want the graph to only count rows with the same ID once.  The data set and subsequently the graph will be occassionaly updated.  Please help.

ID  Owner  End        Title       Time

7   Ted        White     XD          9:45 1/1/18

7   Ted        Green     GT          9:45 1/1/18

8   John      Blue        PT          9:25  8/8/16

9   Bill         Hazel     TY          11:45 2/6/22

[edhans · Accepted solution]

Use the DISTINCTCOUNT(TableName[ID]) Function. It will return 3 in the example above.

You can use the Table.Distinct function in Power query (remove duplicates) on the ID row, but it will delete the 2nd row there, which is likely not what you want unless you are ok to use the info for Ted/Green/GT.