Create measure referencing columns from different non-related tables

[l0ll0]

Hi everybody!

My model is composed of 2 fact tables, 3 dimensions tables related among them, 1 calendar table.
The relationships are eefined ad in the picture:

I need to create this matrix visualization:

• in columns there are 3 fields taken from AREA_DELIVERY and STORE_DELIVERY
• in rows there is filed d_date from CALENDAR

Inside such matrix a measue has to return BLANK() if the date is before or equal to a specific date. the logic I used is the follwoing:

logic_blank_dates = 
IF(
    MAX('CALENDAR'[d_date]) <= TODAY(),
    BLANK(),
    1
)

But it does not work, as it brakes the context showing inconsistent results and all the combination of the three fileds, ignoring any filter applied from outside.

When the measure is inside the viz it works properly identifying the date in the row, but at the same time the measurehas to relate it with the fields in the columns of the matrix. Since the tables of the fields in the columns are not related to the CALENDAR the measure returns an incorrect result.
Is there a way to fix this inside a measure?

Thanks a lot!

[ThomasWeppler]

Hi I0II0

When I look at you data model it looks like your calender table and your  AREA_DELIVERY and STORE_DELIVERY table are not connected.
I know this might be a stupid question, but have you tried to connect the two tables?

[l0ll0]

Thanks  @ThomasWeppler  for answering!

Definitely not a stupid question! There is no way to connect them, because CALENDAR has only dates-related dimension, while AREA_DELIVERY and STRORE_DELIVERY have sales-related dimensions and no dates are involved. 

I tried all the functions that could be useful to avoid the filtering from the columns ( ALL(), REMOVEFILTERS() .... ) but nothing works as well.

Thanks a lot