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!
L4TET
Hmmm that is really strange - I just pulled up the sample data set again and recreated it, but I am getting the intended result (showing zeroes) again.
Can you share your measure to better see what is going on? Also, is your data format in number or text? If it is text (and for whatever reason it has to be a text format), you can try
Measure =
IF( ISBLANK ( [Measure] ), "0", [Measure])