Forum Discussion

kristel_tulio's avatar
kristel_tulio
Icon for Helper III rankHelper III
3 years ago

Job Number not filtering by date

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.

 

 

 

 

 

 

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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]
    )