Edit: Solved thanks to Sam Ovenshine below, using (count([Driver Number]),all([Driver Number])) gives the result I'm looking for in the given example.
I'm trying to calculate the percentile for all members of a dimension on a particular metric to display in a pivot table (below). I can calculate the rank for each row, but I can't find a function to get the number of members after filtering (the maximum rank) to calculate the percentile. Is there such a function?
(see https://drive.google.com/file/d/1jCwg6G_O1AlKSskz09KtbA_HNfInwGdq/view?usp=sharing for the table).
Please sign in to leave a comment.