Filtering by MonthYear hides the dimension that have no values in this month

[Patrick4]

Hello all,

In the straight table the number of contracts are counted by the categories 'Late Payments'. I want the categories to be always displayed and zero values included. If the Date filter is not set, I get the desired result. All 3 categories are displayed. As soon as I filter by the MonthYear, only the actual accruing late payments are displayed. The goal is to have the dimensions displayed consistently in each month and for example in March 23 the category '61-90 days' counts 0 contracts.

I use following function 

Count(distinct token_id)

And I also tried to use 

If(Count(distinct token_id)=0, 0, Count(distinct token_id))

Include null values and include zero values is selected

Do you have any idea how I can make this work?

Thanks a lot
PatrickStraight table without filter

[BrunPierre · Accepted solution]

Count(distinct token_id) + Sum({1} 0)

[Patrick4]

Thanks! It works.