Forum Discussion
Simple Measure showing incorrect values
Hi,
I have added some text boxes to the report page in the attached pbix file.
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
2 Replies
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.
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?
