Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need help to solve the below:
I have a table consisting of my cases. This table has an ID field. I want to get data from my calculation table, this table also have an ID field (many times) as well as an hours field. I want to get the total amount (sum) of hours for each ID in the case table.
I have tried several things, without luck.
Total hours = LOOKUPVALUE('CG$PV Job Calculation Detail'[Timer kalkuleret];'CG$PV Job Calculation Detail'[ID]='CG$PV Case'[ID])
Hi @kseeger ,
Are the tables joined by a relationship? 1 to many? Then you should be able to traverse that relationship to get the data. Are you doing this in Power BI?
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
@kseeger ,
Here is the measure and below is the relationship.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
f
Proud to be a Super User!
Hi @kseeger
If you change the relationship filter to single, you can drop the two columns on a matrix with no measure.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |