Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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
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
@VvelardeThank you for the explanation.
Unfortunately I just figured out, that this solution doesn't work, when I use the date-slicer. Do you have an idea?
anybody?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |