Sum of total hrs to get Headcount by Area, valuesteam,...

[ABC11]

Hello,

I would like to have headcount by area, valuestream, businessunit

I added column to get employee total hrs for that day(without breaking into area, valuestream,businessunit) but getting incorrect(see- in bold, Italic,underline)

Employee Total Hrs =

VAR _VendorName=Query1[VENDOR_NAME]

VAR _RowHours=Query1[LABORHRS]

VAR _LaborCode=Query1[LABORCODE]

VAR _Workdate=Query1[WORKDATE]

VAR _Calc=

CALCULATE(

SUM(Query1[LABORHRS]),

FILTER(ALL(Query1),Query1[VENDOR_NAME]=_VendorName && Query1[LABORCODE]=_LaborCode && Query1[WORKDATE]=_Workdate)

)

Return

_Calc

VENDOR_NAME	LABORCODE	CONTRACTOR_NAME	WORKDATE	AREA_NEW	VALUESTREAM	BUSINESSUNIT	LABORHRS	Employee Total Hrs
ABC	30002594A	GEREMY	12/1/2022	H1 BP	HZ EXTRACTION & TAILINGS	280900	5.5	11
ABC	30002594A	GEREMY	12/1/2022	H1 U2	HZ UTILITIES	677000	5	11
ABC	30002594A	GEREMY	12/1/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11
ABC	30002594A	GEREMY	12/12/2022	H1 MINI	HZ MINE GENERAL	100120	11	11.5
ABC	30002594A	GEREMY	12/12/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11.5
ABC	30002594A	GEREMY	12/13/2022	H1 MINI	HZ MINE GENERAL	100120	11	11.5
ABC	30002594A	GEREMY	12/13/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11.5
ABC	30002594A	GEREMY	12/14/2022	H1 MINI	HZ MINE GENERAL	100120	11	11.5
ABC	30002594A	GEREMY	12/14/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11.5
ABC	30002594A	GEREMY	12/15/2022	H1 MINI	HZ MINE GENERAL	100120	10.5	11
ABC	30002594A	GEREMY	12/15/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11
ABC	30002595A	MICHAEL	12/2/2022	H1 U2	HZ PUG	330000	14	29
ABC	30002595A	MICHAEL	12/2/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	14.5
ABC	30002595A	MICHAEL	12/3/2022	H1 U2	HZ PUG	330000	4	13
ABC	30002595A	MICHAEL	12/3/2022	H1 U2	HZ UTILITIES	640000	4	13
ABC	30002595A	MICHAEL	12/3/2022	H1 U2	HZ UTILITIES	650000	4.5	26
ABC	30002595A	MICHAEL	12/3/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	13
ABC	30002595A	MICHAEL	12/4/2022	H1 U2	HZ PUG	330000	11	11.5
ABC	30002595A	MICHAEL	12/4/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11.5
ABC	30002595A	MICHAEL	12/5/2022	H1 U2	HZ UTILITIES	730000	11	11.5
ABC	30002595A	MICHAEL	12/5/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11.5
ABC	30002595A	MICHAEL	12/6/2022	H1 U2	HZ PUG	330000	11	11.5
ABC	30002595A	MICHAEL	12/6/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11.5
ABC	30002595A	MICHAEL	12/7/2022	H1 U2	HZ PUG	330000	11	11.5
ABC	30002595A	MICHAEL	12/7/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11.5
ABC	30002595A	MICHAEL	12/8/2022	H1 U2	HZ PUG	330000	10.5	11
ABC	30002595A	MICHAEL	12/8/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11
ABC	30002595A	MICHAEL	12/16/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	11.5
ABC	30002595A	MICHAEL	12/16/2022	TA-OPEX	HZ UPGRADING	490000	11	11.5
ABC	30002595A	MICHAEL	12/17/2022	H1 U2	HZ UTILITIES	760000	9	29
ABC	30002595A	MICHAEL	12/17/2022	H1 U2	HZ VP AND SUPPORT - U2	300915	0.5	14.5
ABC	30002595A	MICHAEL	12/17/2022	TA-OPEX	HZ UPGRADING	490000	5	14.5

Thanks

[ABC11]

Hello to All,

I need help here. can anybody help me or do I have to post as new

Please

Thanks

[ABC11]

Hello To all,

I need help on this-do I have to post it as new or someone can help me here

Please

Thanks

[ABC11]

Above formula is working perfectly

Thanks

[Shaurya · Accepted solution]

Hi @ABC11,

You can try creating a DAX column for this using:

Sum = SUMX('TableName',IF(_VendorName=EARLIER(_VendorName) && _RowHours=EARLIER(_RowHours) && _LaborCode=EARLIER(_LaborCode && _Workdate=EARLIER(_Workdate),'TableName'[Hours],0))

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

[ABC11]

Happy New Year Shaurya,

would you please, help me here.

Thanks,

[ABC11]

Hello Shaurya,

Sorry it didn't work. would you please take a look again.

Thanks for your time