topic Job Number not filtering by date in DAX Commands and Tips

Job Number not filtering by date

kristel_tulio — Thu, 16 Feb 2023 00:10:54 GMT

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.

Re: Job Number not filtering by date

wdx223_Daniel — Thu, 16 Feb 2023 03:10:06 GMT

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

Re: Job Number not filtering by date

kristel_tulio — Wed, 22 Feb 2023 00:18:31 GMT

Hi wdx223_Daniel ,

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