Total output and output per hour in one matrix

[guyhjs]

I have a 'Production Table' with daily production output from different machines. It has the columns 'Production Date', 'Machine', 'Shift hours', 'Output'.

How can I display a matrix with 'Output'/'Machine Hours' with machine as rows that can be filtered with a slicer for production date?

I need to sumhow do  sum('Output')/sum('Machine Hours') by machine but if I make a table of this the slicer will not change the values.

Please help!

[bhanu_gautam · Accepted solution]

@guyhjs , Try creating a new measure 

OutputPerMachineHour = SUM('Production Table'[Output]) / SUM('Production Table'[Shift hours])

Add a new Matrix visual to your report.
Drag the 'Machine' column to the Rows field of the Matrix.
Drag the newly created measure OutputPerMachineHour to the Values field of the Matrix.
Add a Date Slicer:

Add a slicer visual to your report.
Drag the 'Production Date' column to the slicer.

[guyhjs]

This worked thanks Bhanu