Forum Discussion

rishic's avatar
rishic
Frequent Visitor
8 years ago
Solved

Nested Group by/Summarize with Divide

  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 h...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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] )
)

    Nested_Group_by

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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] )
)

Nested_Group_by

 

Best Regards,

Dale