Forum Discussion
Solved
Show items without data doesn't work for only one filter item
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 g...
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.
roman_gorbunov , the date is coming from another dimension? means not from fact and company table
Yes , it comes from another table (Calendar table)