Best Of
Re: Top Sales Week by Closer
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.
Create 'same' drill path for multiple cards
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?
Re: Ignore some page filters in cards or pages
Currently it's an all or nothing in terms of the interactions however, have you looked into utilizing a FIXED function beast mode with some FILTER DENY to prevent the calculation from being affected by certain columns?

