Filter with orderby

I have two expressions when I use one of them it works, but if I put them together they don’t work. Can someone advise me how can I fix?
First expressions: FILTER(Notary, [Until EXP]=[ORDER])
Second expressions: ORDERBY(Notary[FULL NAME], [NO], true)

I use “And” to combine they together

and(FILTER(Notary, [Until EXP]=[ORDER]),
ORDERBY(Notary[FULL NAME], [NO], true))

ORDERBY(
 SELECT(Notary[FULL NAME], [Until Exp]=[ORDER])  //you may need to add[_THISROW] to [Until Exp]  or [ORDER]
 [NO],
 TRUE
)

ORDERBY(SELECT(Customers[Customer ID], ([Country] = “Brazil”)), [Customer Name]) sorts the IDs of customers in Brazil by customer name. Equivalent to ORDERBY(FILTER(“Customers”, ([Country] = “Brazil”)), [Customer Name]).See also: FILTER(), SELECT()

2 Likes