Power BI result is different from SQL result

Hello gurus,
My sql query result is different from that of my Power BI result. I have a simple query which just pulls the data based on the date entered. Power BI filter shows that it is pulling from the same date as I queried in sql. However, the Power BI result is based on data queried from the full data count.  I have my inner joins and relationship set up in Power BI. Attached are examples of what I'm referring to...

SQL query:

SELECT *

FROM myFacilitySite site
INNER JOIN myQuarantineCase mq ON site.fkeyCaseID = mq.ID
INNER JOIN myCareFacility mcf ON mq.FacilityID = mcf.ID
INNER JOIN lkuClearance lclr ON site.ClearanceStatusId = lclr.ID
WHERE mq.EntryDate BETWEEN '1/1/2022' AND '7/23/2022'
AND lclr.ID = 2 OR lclr.ID = 3
AND mcf.IsActive = 1
GROUP BY mcf.[Name]
ORDER BY COUNT(site.ID) DESC, acf.[Name]

SQL output:

Power BI DAX Studio:

// DAX Query
DEFINE
  VAR __DS0FilterTable = 
    FILTER(
      KEEPFILTERS(VALUES('myQuarantineCase'[EntryDate])),
      AND(
        'myQuarantineCase'[EntryDate] >= DATE(2022, 1, 1),
        'myQuarantineCase'[EntryDate] < DATE(2022, 7, 23)
      )
    )
  VAR __DS0Core = 
    SUMMARIZECOLUMNS(
      'Metrics - Animals On-Hold'[myCareFacility.Name],
      __DS0FilterTable,
      "CountACF_Count", CALCULATE(COUNTA('Metrics - Animals On-Hold'[ACF Count]))
    )
  VAR __DS0PrimaryWindowed = 
    TOPN(
      1001,
      __DS0Core,
      [CountCareFacility_Count],
      0,
      'Metrics - Animals On-Hold'[myCareFacility.Name],
      1
    )
EVALUATE
  __DS0PrimaryWindowed
ORDER BY
  [CountCareFacility_Count] DESC,
  'Metrics - Animals On-Hold'[myCareFacility.Name]

Power BI result - notice the values as compared to the SQL values:

Thanks for you help.