Forum Discussion
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...
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!!
