How to have fixed/static dimension?

[newmcm]

Hi All, 

I have 3 columns in my mock up data. i.e. Unit, Epi_month, Name. 

I plotted them on a graph, dimension: Epi_month, measures: Count(distinct name)

I have a filter: Unit. 

When i filter for a unit, the graph and dimension reduces to:

Is there anyway I can continue to show -11 to 10 in the dimension. So those missing values are shown as 0 in the graph?

Edit: attaching my mock up data as well.

[benvatvandata]

See if changing your measure to this works:

count({1} aggr( count([distinct name]), Epi_month))

- Ben

[rubenmarin · Accepted solution]

or maybe:
Sum({1} aggr(count(Name), Epi_month))

[newmcm]

Hi, is this for the measure or dimension?

[newmcm]

---

@benvatvandata wrote:

See if changing your measure to this works:

count({1} aggr( count([distinct name]), Epi_month))

- Ben

---

Wouldn't this makes my filter for useless already? 

[newmcm]

---

@rubenmarin wrote:
or maybe:
Sum({1} aggr(count(Name), Epi_month))

---

Thanks! this works wonder! 

Would you be able to explain the rational/logic behind please?

[rubenmarin]

Hi, it counts Name's for each Epi_month, all inside a sum to keep the value ofthe insider Sum, and using {1} to ignore selections and allow to show all dimension values.

It's very similar to the one posted by @benvatvandata, just changed the Count by a Sum, because the count will return 1, but the sum keeps the value of the insider Count().