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))Screenshot 2023-01-10 at 1.23.49 AM.pngScreenshot 2023-01-10 at 1.23.33 AM.pngScreenshot 2023-01-10 at 1.20.08 AM.png



0 1 83
1 REPLY 1

 

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 cu...

Top Labels in this Space