Forum Discussion
Solved
Measure with filter and row context
Hi all, I have a Powerbi issue where I need some help. Consider the following data tables: Data Table 1: Employee list Name ID Manager ID Job title John 1 CEO ...
louisdeg , try a measure like
MANAGER SCORE = calculate([SURVEY SCORE],FILTER(allselected('Employee List'), 'Employee List'[Manager ID]= max('Employee List'[ID])))
amitchandak
Super User
Super Userlouisdeg , try a measure like
MANAGER SCORE = calculate([SURVEY SCORE],FILTER(allselected('Employee List'), 'Employee List'[Manager ID]= max('Employee List'[ID])))
Wow, I think it worked! Thanks a lot amitchandak !!