You could add
left join (FuseActions) LOAD
concat(Fuse_Action,'-',Fuse_Action_ID) as FQPath,
Resident FuseActions group by Path;
and then do a distinct count on FQPath.
Hope this helps,
You could also use an autonumber() around the concat to create a number instead of the lenghty text (or both), could be more performant. And you don't necessarily need the left join, you could also keep the tables just linked.