Forum Discussion
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?
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
5 Replies
anybody?
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
I don't understand exactly, how your solution works, but it does work perfectly, thx for that!
Hi, The measure work in this way:
First i declare two variables :
1. With the MaxSale (Your measure)
2 A variable to store a "temporal table" with the summarize of employees and his sales.
After that create a 1 column table (in this case with Values) of the employee where the sales are equal to MaxSale
The issue is when 2 employees had the MaxSale. In this case you should evaluate what desire to show. Only One Employee or Both.
Regards
Victor
Lima - Peru
