Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear all,
I have some trouble with DAX measures and I don't know how to solve it. This is my data model:
I'm trying to make several measures, but I can't get them correct, because of the different dimension tables.
These are the measures:
I tried to get it fixed with USERELATIONSHIP to define which relationship the measure should use. But this does not work.
Measure = CALCULATE(SUM(tbl_Cost[Cost]); USERELATIONSHIP(tbl_Cost[Costkey];tbl_Trucks[Costkey]))
Can someone please help me?
To clarify I made a demo file which you can find here:
https://www.dropbox.com/s/bx9nwl246qjpg1p/180528%20Demo%20file.pbix?dl=0
Many thanks in advance.
@BWL,
You may try using LOOKUPVALUE Function to add calculated columns first.
Hi @v-chuncz-msft,
Thanks for your reply!
Do you mean:
So instead of making a measure, make calculated columns in tbl_route with LOOKUPVALUE?
Regards,
BWL
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |