Show items without data doesn't work for only one filter item

[roman_gorbunov]

Hello!

I met with such an unusual problem: In the table there is a list of dates for the current month, in the filter there is a list of companies.  

When I select any company in the filter, I get a list of January dates, but when I select one company (Volkswagen) in the filter, an empty list of dates appears.

The option show items without data is enabled. There are no other applied filters, including in the filter panel.

If the behavior was the same for all companies in the filter it would be clearer, otherwise it’s not clear at all where to look for the reason. Any ideas? Thank you in advance for your reply.

[roman_gorbunov · Accepted solution]

Found the reason. The point is in the chain of active links and the fact that one of the tables has  "many-to-many" relationship with the calendar and double filtering in both directions, while in the other tables "one-t-many", I changed link filter type to "one" (the calendar filters the linked table) in the problematic relationship and everything worked.

[amitchandak]

@roman_gorbunov , the date is coming from another dimension? means not from fact and company table

[roman_gorbunov]

Yes , it comes from another table (Calendar table)