Ratio between two unlinked tables based on year_month

[AntSto]

Hello, 

I'd like to calculte a ratio between two unlinked tables, so my first step was to try and see if I could get my count and divider in one table before dividing them:

One of my problem is that I don't want to link Date_1 with Date_2  as I want to make sure I get the full divider (not taking into account any possible filter for the Date_2, where date_1 could be filtered)

I tried the following to get the count(divider) in my table 1: column CT:

=count({<[Date_2.autoCalendar.YearMonth]=[Date_1.autoCalendar.YearMonth]>} [dividier])

but it results in 0 everywhere.

I tried also (column ct3)

=count({<[Date_1.autoCalendar.YearMonth]=[Date_2.autoCalendar.YearMonth]>} [dividier])

but then I get the full count of divider (2085) for every year_month

I've tried to create a new column in the loading phase (Monthname([Date 1]) as Date_1_ym) and the same for Date_2 to make sure they had the same formatting (default column were timestamps and date but I figured choosing auto.calendar.YearMonth would make them comparable) and then to do :

=COUNT({<[Date_2_ym]=[Date_1_ym]>} [divider]) but it gives me 2085 for every line (same as CT3)