The Distinct functions works in Power Apps quite predictably – I mean analogically to DAX or SQL.

For example you can use it to create a selection menu – like now you can select a color from this table:

Insert a ComboBox control. As items you can simply use a column, but then these items are seen duplicated:

So let´s use the Distinct to wrap the column.

now you only see the list of unique values: