Get data from other table one to many.

[kseeger]

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

[Nathaniel_C]

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

[Nathaniel_C]

@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

[Nathaniel_C]

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