Get the count of recent transaction

[xRTP]

Hello,

I've created a new column to get all the recent transaction on Received Date, and drag that to values are but it supposed to show only 18 transactions 10 to adhoc and 8 to onshore. 

CANew Volume =

CALCULATE(

MAX('CA Mailbox'[Received Date]),

FILTER(ALL('CA Mailbox'), 'CA Mailbox'[Received Date] = EARLIER('CA Mailbox'[Received Date])

))

[v-luwang-msft]

HI @xRTP ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[Anonymous]

Try using RANKX DAX
Something Like this.

CANew Volume =

RANKX(ALLSELECTED(CANew Volume[CA Mailbox'[Received Date]), CALCULATE(MAX(CA Mailbox'[Received Date])))
And in visual filters, filter down CANew Volume to 1(Rank)

Please let me know if this works.
Thank You