05-24-2017 09:35 AM
Can you share the formula for the Top/Bottom slicer?
I created switch statements following Sam McKay's setup. Everything works, but I cannot get the ranking to show top or bottom performers.
Here's the thread with the switch formula. You'll need to adjust to your specific report.
Thanks for sharing the file. I was trying to add a Rank column and I copied and pasted the codes in Rank measure to the customized column. But it did not return the rankings. Just trying to figure out why, thanks.