DAX Total does not match sum of rows

[N_R_000]

Thanks to some help on here, I've progressed but could do with a final bit of help. 

I need to calculate the overall Target for the selected users (users are filtered by Slicer, by team etc). I have the below, but you'll see that the totals at the bottom are not correct for Target. I need to get a total overall target, even if I have to display it in another visual. 

Data is in 3 tables: 

A date table

A Users table - single row per user, with a Productivity Target per user.

A table containing orders, the rows are input by each user.

A Schedule Table which confirms if the user was scheduled to work that day, joins to Users on UserID

The Order table sits in the middle, and connects to the Users table by UserID and to the Date table by DateID.

The Target is only to be counted (or sum'd) if that user worked that day. 

Target Per Person = 

IF ( ISINSCOPE(Person[person_name]), 'DAX Measures'[Target],
var summaryTable = ADDCOLUMNS( SUMMARIZE( Person, Person[person_name]), 
"@val", [Target])
return SUMX( summaryTable, [@val])
)

Target = 'People'[Target]*[CountofWorkedDays]

Can anyone help me with a measure that would SUM the Targets for staff (if they worked that day)? 

[amitchandak]

@N_R_000 , Try like

Target Per Person =

IF ( ISINSCOPE(Person[person_name]), 'DAX Measures'[Target],
var summaryTable = ADDCOLUMNS( SUMMARIZE( Person, Person[person_name], 'Date'[Date]),
"@val", [Target])
return SUMX( summaryTable, [@val])
)

[N_R_000]

Hi, thanks for getting in touch - I don't have a Date  column on the Person table though, so the DAX editor is throwing an error. I only have a date column on the Dates table. 

Also - I'm happy if this measure sits in it's own Card visual (doesn't have to be part of the existing Matrix)