Forum Discussion

thuetten's avatar
thuetten
Helper I
6 years ago
Solved

Displaying Detail data with Summary data

Hey all,   I have two tables I'm working with, a detail table and a table more summarized costs. The detail table contains internal costs on a per - line level, and the summary table contains exter...
Need Help
  • thuetten's avatar
    thuetten
    6 years ago

    I figured this out after looking at VasTg's reply.

     

    I created a new table with the distinct ID and ID2 columns, and then joined it to both the detail and the summary table. I used ID and ID2 for the rows in the matrix, and then values from both the details and summary columns worked as expected in the matrix.

amitchandak's avatar
amitchandak
Super User
6 years ago

Looking at your data ID, ID2 seems like a unique combination. So you can create a concatenated key and use that join 

 

new Key = ID & "-" & ID2.

 

Or in summary, you can have a new column like

Max Cost in Summary  = maxx(filter(Detail ,Summary [ID] = Detail [ID] && Summary [ID2] = Detail [ID2],Detail[	Internal Cost])

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

 

thuetten's avatar
thuetten
Helper I
6 years ago

amitchandakThere's actually a couple more columns that make it distinct, but I did concatenate all of those columns and joined it that way. It worked, because there is a 1 to many relationship and it does work if I display the data above in a table. It just won't work once I switch it to a matrix.