Nested Group by/Summarize with Divide

[rishic]

I have my base data something like this and finally would want to show a graph with sales_area and value highlighted in yellow.

The values are QtyperHour=divide(sum(qty),sum(tothours))

I have tried to use nested group up with divide, can someone pease share how to use nested group by/summarize with divide.

[v-jiascu-msft · Accepted solution]

Hi @rishic,

Actually, you don't need the function "Summarize". Please try out the formula below.

Measure =
DIVIDE (
    SUM ( Table1[Pur_quantity] ),
    SUMX ( VALUES ( 'Table1'[Tot_Hours_Spent] ), [Tot_Hours_Spent] )
)

Best Regards,

Dale