cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kseeger Frequent Visitor
Frequent Visitor

Get data from other table one to many.

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

3 REPLIES 3
Super User IV
Super User IV

Re: Get data from other table one to many.

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Super User IV
Super User IV

Re: Get data from other table one to many.

@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

 

 

 

Cases.PNGf

 

Cases1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Super User IV
Super User IV

Re: Get data from other table one to many.

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

 

Cases 3.PNG

 

 

Cases2.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors