The reason it is not showing up is that there are no records that match that element of the calculated dimension (as you know). I had a similar issue come up in the past and I was unable to resolve it while using a calculated dimension. Since there is nothing that matches that element of the dimension, it will never show. It gets even worse when you start making selections.
Eventually, I created an inline table to store the values I needed for the dimension. Something like:
LOAD * INLINE [
_Low, _High, _Label
26000, 26999, 26000 <= x < 27000
27000, 27999, 27000 <= x < 28000
28000, 28999, 28000 <= x < 28000
You can then build the expressions using a complicated nested if statement or it can also be done using an Aggr function. Neither are very easy to put together, but it should be able to do what you want.
I was able to modify the expression I used to work with your data. Here is the expression needed. I'll post a sample as well.
If(Aggr(Sum(VALOR), PRODUTO, _Label) >= _Low and
Aggr(Sum(VALOR), PRODUTO, _Label) < (_High + 1)
Histo.qvw 151.0 K