USERRELATIONSHIP

Hi fazou ,
Thank you for reaching out to us on Microsoft Fabric Community Forum!

Upon my understanding,I tried to recreate it on my end.So I followed below steps which might help you to resolve the issue.

1.Create a calulated column using below:

SegmentAtSaleDate =

CALCULATE (

    MAX ( 'TBF_SEGMENTATION_HISTO'[SEGMENT] ),

    FILTER (

        'TBF_SEGMENTATION_HISTO',

        'TBF_SEGMENTATION_HISTO'[CUSTOMER_ID] = 'TBF_SALES'[CUSTOMER_ID] &&

        'TBF_SEGMENTATION_HISTO'[START_DATE] <= 'TBF_SALES'[ORIGINAL_ORDER_DATE]

    )

)

2.Then create a measure using below:

TTotal Sales CY by Segment =

VAR SelectedStart = MIN('TBD_PERIOD'[START_DATE])

VAR SelectedEnd = MAX('TBD_PERIOD'[END_DATE])

RETURN

CALCULATE (

    SUM('TBF_SALES'[NET_SALES]),

    FILTER (

        'TBF_SALES',

        'TBF_SALES'[ORIGINAL_ORDER_DATE] >= SelectedStart &&

        'TBF_SALES'[ORIGINAL_ORDER_DATE] <= SelectedEnd

    )

)

3.Please refer the screenshot and file for your reference:

Hope this answer meets your requirements.If so,give us kudos and consider accepting it as solution.

Regards,
Pallavi.