Need help with data not showing

[Jakair123]

Hi I have been given a task to fix an issue with power Bi. I Have attached a document down below to help you understand what i am trying to say. Picture 1 the "certificate overview" it shows 347 HMO certificates expired. But on picture 2 in the HMO section it only shows 16 properties(Highlighted in red) I am not sure why its not showing all the houses that have an expried HMO certificate. Hope that make sensePicture 1 . Under the "Expired Column" it shows 347Picture 2. under "Max of safetycertificates_DaysuntilDue" the column highlighted in red shows the properties where the HMO have expired. But it only shows 15

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...