Forum Discussion
StefanK
8 years agoNew Member
Data Labels in Table
This is my Table in Power BI Desktop and the according Data Sheet: How can I show the Name-Code of the Employee in the Power BI Table, next to the Quick Measure with his Sales?
- 8 years ago
Hi, Please try with this measure:
EmployeeCode = VAR SALEMAX = [Sale max per Employee] VAR TABLEEMPLOYEE = SUMMARIZE ( Table1; Table1[Employee]; "SALES"; CALCULATE ( SUM ( Table1[Sale] ) ) ) RETURN CALCULATE ( VALUES ( Table1[Employee] ); FILTER ( TABLEEMPLOYEE; [SALES] = SALEMAX ) )Regards
Victor
Lima - Peru
StefanK
8 years agoNew Member
anybody?