Forum Discussion
Solved
How Many Separate Cases (Distinct Case Numbers) Are Really In My Data Set??
Hi, is there an obvious reason why the measure I created to count all the distinct case numbers in my report, Total Cases = DISTINCTCOUNT ('M43'[Case Number]), is over 200 cases less than what the di...
Hello,
Dumb question: Is that not a year filter in the top right? Unless there is only 2022 data in M43 and/or there is no existing relationship between whatever table that 2022 filter is in and the M43 table?
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Oh my goodness you are right, my new-user mind completley missed that. It all adds up now. Thank you for looking into it and catching in a screenshot what I couldn't in the whole workbook. Apprecaite it!
haha no worries, sometimes it just takes a second pair of eyes. 😄