Forum Discussion

neil37's avatar
neil37
Advocate I
5 years ago

Complicated Distinct Count

Hello,    I am having issues accurately counting occurences of specific crimes due to identical rows that cannot necessarily be removed by "removing duplicates" because the CR, CRno, and Caseno may...
Need Help
neil37's avatar
neil37
Advocate I
5 years ago

Hi! Thank you for the quick response!

 

The reason I cannot use the Dinstinctmeasure that I already created  (e.g., =DISTINCTCOUNT('tablename'[caseno])) because the new measure I am creating requires a Table Column (see below):

 

 

 

I am attempting to calculate the crime count last year, as well as the Difference between the Current Year and Last Year. I have the measures created but the caseno column is not distinct in the data so the sums are incorrect.

 

I am a bit new to PowerBI so if you have a different formula to use to calculate Last years Crime Count using a distinct count measure and not columns, I am open to suggestions! 

 

Thank you for your help!!

neil37's avatar
neil37
Advocate I
5 years ago

Ultimately, the new calculated column within our table would have a 1 or 0 if that specific row was counted as "distinct" when you instruct PowerBI to "Count(Distinct) within a visualization (That is how we have determined  the most accurate way to count the number of unique crime counts). If that does not make sens,e please let me know and I will try to explain it better.  AlB  Thank you!!

  • AlB's avatar
    AlB
    Community Champion
    5 years ago

    neil37 

    Sorry. I don't get it 🤔

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers