Integrate Orderby function with Select function

[Skip2MiLu]

How do I go about integrating the ORDERBY function into the below SELECT function I have working as my Valid_if for the [Country] column in the LOCAL PRODUCT ASSORTMENT table.

1. I want to order the result of the below select funtion list of keys in INVENTORY OWNER[Country], by the [Country] column in the COUNTRIES table.
2. The COUNTRIES table key column is [Country No] and the label column is [Country] mentioned in point 1, and the [Country] column in the LOCAL PRODUCT ASSORTMENT table is referenced to the COUNTRIES table.

SELECT(
	INVENTORY OWNER[Country],
  ([Sales Unit] = [_THISROW].[Sales Unit])
)

[TeeSee1 · Accepted solution]

How about

ORDERBY(
 SELECT(
  INVENTORY OWNER[key col],
  [Sales Unit] = [_THISROW].[Sales Unit]
 ),
 [Country]
)

[Joseph_Seddik]

ORDERBY(
  FILTER("Inventory Owner", [Sales Unit] = [_ThisRow].[Sales Unit]), [Country]
)