Best Of

@Clinton Your logic should work, though for future reference you can simplify it using an “is null” operator like below:

case when Parent Carrier ID is NULL then Carrier Name else Parent Carrier Name end

I found a solution. I've used Row_Number to eliminate ties in the rank and I removed the week of year and year from the partition:

Row_Number() over (PARTITION BY Closer.FullName ORDER BY COUNT(DISTINCT Opportunity Id) DESC, WEEKOFYEAR(Project.SaleDate), YEAR(Project.SaleDate))

I then filtered for weeks with a row number of one on a table with a list of closers, sale weeks and number of sales.

Does anyone know of a way to create drill paths for multiple cards formatted the same way? I have several cards with similar data (same column names) and would like to create a drill path table for all of them, but would prefer not to do it 20 times. Thoughts?