How to display Grand Total correctly with USERELATIONSHIP?

Good day,

I’m having trouble with getting the correct Grand Total for my pivot table.

I have two tables.

• Fact table of email worked by an employee. It has a pkey column which is just a concatenation of week and agentId.
• Dimension table that has the login data of employee. It has an active citrixKey connected to Fact table.In general, Fact.agentId is the same as Dimension.citrixUsername, however an employee encountered issues with the citrixUsername and is now using Dimension.ntLogin. When I tried to build a pivot table with rows as agentId and values as sum of values, the grand total is not correct.
  
  Here are my measures:
  
  sumEmails:=
  SUM( 'Fact'[Value] )
   
  calcEmails:=
  IF( 
  [sumEmails] = BLANK(),
  CALCULATE(
  [sumEmails],
  USERELATIONSHIP('Fact'[pkey], 'Dimension'[ntloginKey])
  ),
  [sumEmails]
  )
  
  
  

Sample