Drop Down list for column in table

Hi bslozano 
According to your description, you need to use a slicer.

Please refer to the linked guide:

https://www.spguides.com/add-a-dropdown-slicer-in-power-bi/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Hi bslozano ,

It sounds like you want to create a dynamic table that changes based on the selection of a drop down menu. You can try to use a slicer visual and a measure.

Drag and drop the Employee field from your source table to the slicer. This will create a drop down menu with the list of employees.

Next, you need to create a measure that calculates the distance for the selected employee. You can use the SELECTEDVALUE function to get the value of the slicer.

Distance =
CALCULATE (
    SUM ( 'Table'[Distance] ),
    'Table'[Employee] = SELECTEDVALUE ( 'Table'[Employee] )
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.