As a long time Tableau user I’m still learning how to use Dax to create measures and columns in Power BI. I have the unique_id for each person and this id is generated several times based on location and Type. See my data below:

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

Any idea how I can utilize DAX to create a measure and get the count to be 3 since there are only 3 different values in the unique_id column?

Thanks,

DW