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 %.
Solved! Go to Solution.
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.