Using RankX and AddColumn to a Virtual Table

I am trying to create a formula that will first rank the data based on the [Date-Calendar] column grouped by the Claim Num (Full), then count the rows where the Rank = 1.    Here is my formula:   ...