Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kristel_tulio
Helper III
Helper III

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".

kristel_tulio_0-1676505933245.png

 

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

 

kristel_tulio_2-1676505964974.png

 

kristel_tulio_3-1676505993066.png

kristel_tulio_4-1676506242345.png

 

 

 

 

2 REPLIES 2
wdx223_Daniel
Super User
Super User

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

Hi @wdx223_Daniel ,

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors