Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
FRG
Resolver I
Resolver I

% of piece for each employee

Hi,

In this table visual I have some users, grade ID and count of pieces produce.

Capture.JPG

 

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

 

1 ACCEPTED SOLUTION

Find it. I create this measure:

 

Measure = 
DIVIDE(COUNT(Table1[idPiece]);
CALCULATE(COUNTA(Table1[idPiece]);ALL(Table1[idGradeQuality])))

Thanks.

View solution in original post

3 REPLIES 3
manalla
Helper V
Helper V

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.