Is there a reason you've turned off the "Aggregate Measures" option (on the Analysis menu)? By doing this, it won't aggregate your measures, so they'll act more like dimensions. If you turn that on, you'll get this:
There's still a problem though because you're using sums. You may wish to use AVG or something else.
Thank you for your reply.
Unfortunately, aggregating measures is not the solution. I've dis-aggregated them because this data is linked to a shapefile looking at individual school district. That point aside, my broader point is that the observation is counted twice (if you look at the data by right clicking it shows the same identical observation twice).
For context, I'm looking at graduation rates of all students (one of the filters), for the 4-year cohort (another filter), during 2017 (another filter). And yet, there's two observations at 68 percent for advanced regents (type) of graduation.
I'm utilizing sums because it's just one observation, there's nothing being summed.
Just drag your school id dimension in Details card and you'll be able to see that you have two different School id with same value.
That's why you are getting this.
Try to see this once.
Thank you Suman!!!
The problem is in the shapefile, as it has two school ids that fall under the same school district (I suspect they have two high schools, for example).
Filtering one of them out ends the duplication.
Thank you again.
Please kindly mark this answer as correct or helpful so that it will helpful for others