Complicated Distinct Count

Great question! For your issue, it seems you need to create a calculated column that groups by the offense type while keeping your index column (CR) intact. One way to handle this is by using DAX with the SUMMARIZE function to create a new table that aggregates the offenses based on unique CR and offense type combinations. Alternatively, you can use GROUPBY if you're working directly within Power BI.

For further reference, you might also want to explore Virginia arrest warrants or similar records to cross-check how categorization of offenses is handled in real-life datasets. Here's a resource that might be helpful:  VA Arrest Warrent. This could provide some useful insights into structuring your data accurately. Let me know how it goes!