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.
Hi,
In this table visual I have some users, grade ID and count of pieces produce.
I want the percentage of each grade ID for each employee.
EX: Employee #9 produces 192 pieces. He produces 35 pieces of grade ID #49 = 25,5 %.
Thanks
Solved! Go to Solution.
Find it. I create this measure:
Measure = DIVIDE(COUNT(Table1[idPiece]); CALCULATE(COUNTA(Table1[idPiece]);ALL(Table1[idGradeQuality])))
Thanks.
Hi,
Create a measure to calculate % as you require, Power BI will roll up based on the group by and will calculate the % for you. Measures are calculated run time.
If you want the % in a different column instead of measure, first create a SUM with group by - refer https://community.powerbi.com/t5/Desktop/Sum-of-values-by-each-category/td-p/134279
Then use this new column to calculate row level % for each grad and employee in your case.
Thanks
Find it. I create this measure:
Measure = DIVIDE(COUNT(Table1[idPiece]); CALCULATE(COUNTA(Table1[idPiece]);ALL(Table1[idGradeQuality])))
Thanks.
In the table each pieces is a row. I think I can not do it with a calculated column. I look for a measure but dont't know how to do it.
Thanks for your help.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |