Forum Discussion

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
8 years ago
Solved

Sum on the Row then Columns

Seems this should be a simple exercise but it escapes me. I have a Manpower table that lists all employees. I have a table of Hours related to Manpower, where each employee will have many time entr...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago

    ToddChitt

    You can try a measure as below. See more in the attached pbix file.

    Measure =
VAR sumizedTble =
    SUMMARIZE (
        Manpower,
        Manpower[Depart],
        Manpower[EmpID],
        "subtotalHours", SUM ( Hours[Hours] ),
        "subtotalRate", SUM ( Rates[rate] )
    )
RETURN
    SUMX ( sumizedTble, [subtotalHours] * [subtotalRate] )

     

    3*1.1+5*0.5=5.8

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

ToddChitt

You can try a measure as below. See more in the attached pbix file.

Measure =
VAR sumizedTble =
    SUMMARIZE (
        Manpower,
        Manpower[Depart],
        Manpower[EmpID],
        "subtotalHours", SUM ( Hours[Hours] ),
        "subtotalRate", SUM ( Rates[rate] )
    )
RETURN
    SUMX ( sumizedTble, [subtotalHours] * [subtotalRate] )

 

3*1.1+5*0.5=5.8