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 ...
Need Help
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