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
)
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |