I have the unique_id for each person and this id is generated several times based on location and Type. I utilize the following code DistinctCount(Table1[unique_id]) and this returns all the ids instead of the unique ones.

unique_id type location
1 Red East
1 Blue West
2 Blue West
3 Red East
3 Blue West
3 Green North

This returns a distinct unique_id count of 6. Any idea how I can get the count to be 3?

Thanks,

DW