Data modeling - create a relationship and filter a dimension

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Sales: =
VAR _ProductByMarkdownTypeByDate =
    SUMMARIZE (
        GENERATE (
            markdown,
            FILTER (
                'calendar',
                'calendar'[Date] >= markdown[markdown_startdate]
                    && 'calendar'[Date] <= markdown[markdown_enddate]
            )
        ),
        markdown[article_id],
        'calendar'[Date]
    )
RETURN
    IF (
        ISFILTERED ( markdown_type[markdown_type] ),
        CALCULATE (
            SUM ( sales[sales_amount] ),
            TREATAS (
                _ProductByMarkdownTypeByDate,
                'product'[article_id],
                'calendar'[Date]
            )
        ),
        SUM ( sales[sales_amount] )
    )