Measure with condition IF does not summarize in Visual

[darko861]

Hi I have the following visualization which is a Table

The worked hours column is a measure that looks like this 

Worked Hours = IF([Diff]>=0,SUM(v_rpt_apticcustom_Employee_Time_Billingv6[Registered_Hours]),SUM('apticproject view_workedtime'[Worked.1]))

as you can see it checks the Diff column: 

Diff = SUM(v_rpt_apticcustom_Employee_Time_Billingv6[Registered_Hours]) -[Worked PW]

The Worked Hours gives the correct values but the total 18213 is incorrect

So I tried a new measure Worked Hours3: 

Worked Hours3 = sumx(VALUES(PW_ACM_user[Fullname]),IF([Diff]>=0,SUM(v_rpt_apticcustom_Employee_Time_Billingv6[Registered_Hours]),SUM('apticproject view_workedtime'[Worked.1])))

Worked Hours3 gives me the exact same correct values but the total 2283955 is incorrect.

I would appreciate it if you could give some tips on how to get the visualization to get the correct total of worked hours column?

[amitchandak · Accepted solution]

@darko861 , more than one group in table, Try like

sumx(summarize(PW_ACM_user,PW_ACM_user[Fullname],PW_ACM_user[Deaprtment], "_1",IF([Diff]>=0,SUM(v_rpt_apticcustom_Employee_Time_Billingv6[Registered_Hours]),SUM('apticproject view_workedtime'[Worked.1]))),[_1])

[darko861]

Thanks @amitchandak it worked great! I really appreciate your contribution to this community.