Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with Calculation

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

DateWork CenterWork OrderLabor Produced
1/5/2020A1125
2/5/2020B21110
1/5/2020C3515
2/7/2020D492
1/5/2020E5254
2/5/2020A136
1/5/2020B2458
2/5/2020C31220
1/5/2020D43225
2/7/2020E5640

Can anyone help me get started?

 

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

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

     

    Put Date in the axis

    Put Work Order in the Legend

    Productivity in the Values

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    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