Add columns to calculated table

[boehnc]

I've got this thing going on...have a calculated table (tble) and I'm trying to add the Target_Total field from the TBL_Enrollee_Target table, linked by Site_ID..and am drawing a blank. TIA for any help.

LeaderBoard =



var k=filter(Enrollees, Enrollees[Site ID]<>blank())

var tble = CALCULATETABLE(SUMMARIZE(Enrollees, Enrollees[Site ID], Enrollees[Site Name],"Count",count(Enrollees[Site ID])),KEEPFILTERS(k))



return tble

------------------------------------

TBL_Enrollee_Target, TBL_Enrollee_Target[Site_ID], TBL_Enrollee_Target[Target_Total]