Measurement for summing numbers by category but adding 0 where there is no value.

[314mp_M0th4]

Hello, I'm making a matrix:

Where the left hand side is type and right hand side is cost. As you can see each type has a number label, 1.1, 2.3 etc. However there are some number labels missing. There should be a 5.1, 6.4 and 6.5 to add but the thing is there are no records in the cost data for these type labels. Therefor I would like there to be a line for those types but with 0 for cost. Is it possible to do this with measurements?

[Ritaf1983 · Accepted solution]

Hi @314mp_M0th4 

Try to add 0 to your measure...

[your measure]+0

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[314mp_M0th4]

OMG thanks, this is such a simple fix, However doing this, I also get a row with a blank type with cost = 0 which I would like to get rid of as well

[Ritaf1983]

Glad to help 🙂
Can you show what you mean by blank type?

If it is a category from rows, just filter it out from the filter pane...
uncheck the blanks:

[314mp_M0th4]

I just used exclude to get rid of the blank row nevermind