Forum Discussion

Ranneh's avatar
Ranneh
Frequent Visitor
10 years ago
Solved

help needed with a measure

Hi All,   I am looking for a measure in power BI desktop that will allow me create a sum of various rows based on specific criteria. The criteria being the name of employee and the start of week d...
Need Help
  • jahida's avatar
    jahida
    10 years ago

    Try

    Column = CALCULATE(SUM(Table[hours worked]), ALLEXCEPT(Table, Table[Employee], Table[start of week date]))

     

    EDIT: I'm a bit confused, do you want a measure or a column?

Ranneh's avatar
Ranneh
Frequent Visitor
10 years ago

had a typo with the dates, here is the right sample

 

Employeestart of week dateAssignment nameType of assignmenthours workedemployment typeTotal Hours Total OverheadTotal Hours Adjusted
XSunday july 3, 2016a Not Overhead18exempt39939
XSunday july 3, 2016overheadOverhead9exempt39939
XSunday july 3, 2016bNot Overhead0exempt39939
XSunday july 3, 2016cNot Overhead12exempt39939
         
XSunday july 10, 2016a Not Overhead18exempt40940
XSunday july 10, 2016overheadOverhead9exempt40940
XSunday july 10, 2016bNot Overhead0exempt40940
XSunday july 10, 2016cNot Overhead13exempt40940
         
XSunday july 17, 2016a Not Overhead18exempt542340
XSunday july 17, 2016overheadOverhead9exempt542340
XSunday july 17, 2016bNot Overhead0exempt542340
XSunday july 17, 2016cNot Overhead13exempt542340
XSunday july 17, 2016overheadOverhead14exempt542340
         
YSunday july 3, 2016a Not Overhead18Non - Exempt (Hourly)39939
YSunday july 3, 2016overheadOverhead9Non - Exempt (Hourly)39939
YSunday july 3, 2016bNot Overhead0Non - Exempt (Hourly)39939
YSunday july 3, 2016cNot Overhead12Non - Exempt (Hourly)39939
         
YSunday july 10, 2016a Not Overhead18Non - Exempt (Hourly)40940
YSunday july 10, 2016overheadOverhead9Non - Exempt (Hourly)40940
YSunday july 10, 2016bNot Overhead0Non - Exempt (Hourly)40940
YSunday july 10, 2016cNot Overhead13Non - Exempt (Hourly)40940
         
YSunday july 17, 2016a Not Overhead18Non - Exempt (Hourly)542354
YSunday july 17, 2016overheadOverhead9Non - Exempt (Hourly)542354
YSunday july 17, 2016bNot Overhead0Non - Exempt (Hourly)542354
YSunday july 17, 2016cNot Overhead13Non - Exempt (Hourly)542354
YSunday july 17, 2016overheadOverhead14Non - Exempt (Hourly)542354
  • jahida's avatar
    jahida
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    Try

    Column = CALCULATE(SUM(Table[hours worked]), ALLEXCEPT(Table, Table[Employee], Table[start of week date]))

     

    EDIT: I'm a bit confused, do you want a measure or a column?

    • Ranneh's avatar
      Ranneh
      Frequent Visitor
      10 years ago

      Thanks jahida it works!