Simple Measure showing incorrect values

[ArchStanton]

Hi,

I have added some text boxes to the report page in the attached pbix file.

https://www.dropbox.com/scl/fi/z2c9pykget7z4gutuhvsw/Age-Analysis.pbix?rlkey=wvj8rimvy6r00bccszpp9pl...

My COUNTROWS measure is showing a different value to what is actually in the raw data - there are also blanks

which also do not exist in my data.

Can anyone shed some light on what is happening?

Thanks

[WaqarArshad]

After having a quick look, it seems like you measure is including  18 Mths+ and 15-18 Mths data. if you filter your data on Age next April (mths) where the value is >=18, you will see 2 distinct values in the Apr 2024 Age Profile column. 

[ArchStanton]

Thanks, I've corrected that in the visuals above the blue line.
Can you explain why I'm getting 86 Blank Age Profiles in the current cases Total?