Forum Discussion
Solved
Matrix Visual - Not Displaying Zeros
Hello All! First and foremost I apologize as it seems like this question has been asked multiple times with working answers...for everyone else but me. I have spent the better part of the week c...
Hello L4TET ,
I pulled together a rough dataset to hopefully try and recreate your data and the problem. You can consider the following DAX for your Offense count per quarter:Offense Count = COALESCE(COUNT('Table (2)'[SubOffense]),0)This is how my result Matrix looks like:
My initial data looks something like this:
Hopefully this helps!
Hello L4TET ,
I pulled together a rough dataset to hopefully try and recreate your data and the problem. You can consider the following DAX for your Offense count per quarter:
Offense Count =
COALESCE(COUNT('Table (2)'[SubOffense]),0)This is how my result Matrix looks like:
My initial data looks something like this:
Hopefully this helps!