Dependant dropdown with ORDERBY expression

I am trying to figure out how to properly write the dependent dropdown expression using the “ORDERBY” expression to sort the resulting responses alphabetically.

Dependent drop down expression:
IN( [_THIS], SELECT(Inventory Items[Category], [_THISROW].[Factory] = [Category]))

Attempted to add orderby:
ORDERBY(IN( [_THIS],SELECT(Inventory Items[Category], [_THISROW].[Factory] = [Category]),[category]))

I get the error “ORDERBY has invalid inputs”

I’m pretty sure I wrote the expression wrong but I can’t seem to figure out the correct way. Any suggestions?

1 3 458
3 REPLIES 3
Top Labels in this Space