Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
3 years ago

Simple Measure showing incorrect values

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=wvj8rimvy6r00bccszpp9plw6&dl=0

 

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

 

Need Help
Show and Tell

2 Replies

  • WaqarArshad's avatar
    WaqarArshad
    Icon for Helper I rankHelper I
    3 years ago

    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's avatar
      ArchStanton
      Icon for Power Participant rankPower Participant
      3 years ago

      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?