Why is there a duplicate value?

Why does it seem like the one field is showing duplicates (Within 50 Miles) ? Why would that be when the drop-down to filter the values only shows one ?

image

***** Please disregard, I figured it out. There was a SORT COLUMN in the data that was not being updated for some of values**.

Yep. If you would want to filter those out from the actual report you would do that in Power Query.

Nick

Enterprise%20DNA%20Expert%20-%20Small