Help with Calculation

[Anonymous]

I am new to Power BI and I have the following Data Table that I am using. I would like to:

1. Calculate Productivity (Produced/Labor Hour) for each Work Order

2. Then I would like to produce a Bar Graph with the productivity by work Center or by Work Order

3. Also would like to display the data by date

Date	Work Center	Work Order	Labor	Produced
1/5/2020	A	1	12	5
2/5/2020	B	2	11	10
1/5/2020	C	3	5	15
2/7/2020	D	4	9	2
1/5/2020	E	5	25	4
2/5/2020	A	1	3	6
1/5/2020	B	2	45	8
2/5/2020	C	3	12	20
1/5/2020	D	4	32	25
2/7/2020	E	5	6	40

Can anyone help me get started?

[v-lili6-msft]

hi  @Anonymous 

You could also try a measure as below:

Productivity 1 = CALCULATE(SUM('Table'[Produced]))/CALCULATE(SUM('Table'[Labor]))

or

Productivity 2 = SUMX('Table',[Produced]/[Labor])

Then create a Bar Graph visual that Put Date in the axis, Put Work Order in the Legend, Productivity in the Values

Regards,

Lin

[Greg_Deckler]

Productivity (Column) = [Produced] / [Labor]

Put Date in the axis

Put Work Order in the Legend

Productivity in the Values