Job Number not filtering by date

[kristel_tulio]

Hi! I would like to ask how can I my values be filtered by date. Please see my data model below.

I do have 6 tables connected to each other

Job have relationship with Job Register and Job Budget through "Job UID"

Job Register have relationship with Accounts through"Account UID"

Accounts have relationship with Journal Transactions through"Account UID"

Journal Transaction have relationship with Dates through "Date".

I'm trying to get Sum of square meters in Job table but when I select certain year it's not working.

[wdx223_Daniel]

try this

NewMeasure =
VAR _accts =
    SUMMARIZE ( 'Journal Transactions', 'Accounts'[Account UID] )
RETURN
    SUMX (
        CALCULATETABLE (
            SUMMARIZE ( 'Job Register', 'Job'[Job UID], 'Job'[Number - Copy] ),
            _accts
        ),
        'Job'[Number - Copy]
    )

[kristel_tulio]

Hi @wdx223_Daniel ,

Thank you for your response but it's not working still when I change the date in the slicer.