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 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'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

1 Reply

  • 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