Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |