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!
Thank you for being the first to take a shot at my plight. I have implemented your measure, with no success. I am still facing the same blank spaces as is attached in my photo. I used this measure in the same table where all of that data is stored. I have also tried to implement different variations with a separate table, with relationships via cross join. Any other ideas you may have would be greatly appreciated!