I’m trying to create a measure that returns only employee name from the Activity table. I am looking for the top employee and bottom employee based on average activities completed per day.
The Dax below does not return the correct answer for top.
Top Average Daily Requests =
FIRSTNONBLANK(‘Activity’[Employee Name], 1),
‘Activity’,[Daily Requests Rank1]=1
I’m looking for Jonathan as the top
Here is a sample pbix
Sample.pbix (402.2 KB)