Forum Discussion

ClackamasAshley's avatar
ClackamasAshley
Frequent Visitor
3 years ago
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...
Need Help
  • Wilson_'s avatar
    Wilson_
    3 years ago

    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?)

Wilson_'s avatar
Wilson_
Memorable Member
3 years ago

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?)