Calculating a divide for a table - what am I missing??

This will work correctly at all levels, 

Total Cases = SUM(Table[Cases])

Total Hours = SUM(Table[Hrs])

CPH = DIVIDE([Total Cases], [Total Hours])

Hi unknown917,

can you please clairfy better what you want to achieve, showing examples of the 3 levels you are defining?

1 - Cumulative with respect to what?

2 - Unit - what do you mean here? And here the CPH would still need to be cumulative?

3 - Hub - what do you mean here? And here the CPH would still need to be cumulative?

Please show images and clearly point out the desired results including in case slicer etc

Thanks

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI