Problem with blank values

[paulo_scdata]

Hi. I have tried some solutions in the forum but all of them follow another problem for my situation, so I believe this post might be a bit more specific.

I made a measure on Excel that count how many days a ticket has been open for by calculating (Today - Ticket Opening Date), then, based on that column, if a value is over 6 or more, I label it 6+. Then, I made a basic matrix visual where I make a relation between a type of ticket and that measure (named TA). For now, the matrix table looks like this:

But, see, I have no value for 0 or 2 (because they don't exist within TA measure).

I'd like to see all columns from 0 to 6+ even if the values are blank and I still have the non un 6+ column if necessary for any adjustments. Also, if possible, mark where the values are blank with zero.

Thanks a lot for your help!

[v-yalanwu-msft · Accepted solution]

Hi, @paulo_scdata ;

You could create a new table aboult 0-6+;

Then create a measure.

1.create a new table.

New = UNION( VALUES('Table'[Days]),{0,2})

2.create a measure.

values = CALCULATE(SUM('Table'[values]),FILTER('Table',[Days]=MAX('New'[Days])))+0

The final show:

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC2790]

Hey @paulo_scdata 

See if this similar thread helps you deal with ypur problem.

And for highlighting the values where it is zero, you can make use of condtional formatting.

[paulo_scdata]

Hi @PC2790 ,

Thanks for the answer but no, it didn't.

First, I'm sorry, when I said TA was a measure, I meant it is a column. You can't use measures as columns in a matrix, only values. I meant it as a measure of days passed.

Second, as it's not a measure, I can't seem to think of a solution to add numbers that aren't in the column TA, since it's related to it existing or not. I really don't know where to go from here.