Cross Filtering not working

Hi.

I have 3 tables that have a column called "Month ID" (e.g.: 202309, for Sep 2023). These 3 tables have different information for different KPIs. And they also have different amount or records. For instance, the table 1 has records for 6 categories for 202309 and records for only 4 categories for 202310. In the tables 2 and 3 I have values for 202309 and 202310 for different combinations of fields.

When I used a filter based on the Month ID field from each table (each table using it's own Month ID field), it works perfectly.

I tried to create a table with unique values for Month ID from table 1, creating the relationship (1 to many) from this new table with the Month ID columns of the other 3 tables, setting the direction as both. Also tried multiple combination on Cardinality and Direction.

What is heppening: In the first table, when I select 202309, I have values for all 6 KPI categories. It works perfectly. When I select 202310, I have information only for 4 KPI categories. But, using the filter based on the new table, values for categories 5 and 6 are getting 0%. If I used the Month ID from the table 1, the categories 5 and 6 are not presented (that's what is expected).

Cross filtering this new month ID field, from the new table, to the Tables 2 and 3, I also get 0% on the calculation where I don't have records. If I used the Month ID field for each respoective tables, where I don't have values is returning "Blank" (that's  what is expected).

I tried multiple option/solutions I found in this forum and the results are always the same.

If someone have a suggestion on how I can get this to work properly, I'll really appreciate.

Examples:

Table 1 (using the Month ID from this table as filter, filtering 202310, having values only for categories 1 to 4):

Table 1 (using the new table as filter, with unique Month ID values from table 1, filtering 202310)

Thank you very much for your support.