Block dimension so it will not be filtered by other dimensions

[Anonymous]

Imagine that I have a table like this:

Date	Country	income
Day 1	Spain	100
Day 1	Norway	100
Day 2	Norway	-
Day 3	Norway	300

* On day 2 in norway  there is no income, the model does not cross

I create a filter that is Country

And I have an evolution chart where I show the income:

Day 1 -> 200

Day 2 -> 0

Day 3 -> 300

(I have disabled the option "Do not show null values")

Filter by country = Norway and I want it to appear:

Day 1 -> 100

DAY 2 -> 0

Day 3 -> 300

However I still have:

Day 1 -> 100

Day 3 -> 300

How can I block the date dimension (i need show day 2 with income value = 0) so that no value disappears when filter by country, either because it is 0 or because it has no value?

[petter]

For the income column you should specify an aggregation like Sum().

Then the null value will not show and it will not be filtered.

So you should use the expression Sum(income) for your measure and then underlying null value will sum to zero. Sum can never give a null value unless you have non-numeric values in the field.

[sunny_talwar]

Like this?