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

Add result of one table to specific row of another

Hi,

 

A simplified example of what I need. I have these 2 tables:

 

Table 1:

Column 1   Column 2

Line 1         20

Line 2         30

Line 3         10

 

SUM(Column 2) = 60

 

Table 2:

Column 1   Column 2

Line A         10

Line B         5

Line C         15

 

Now I need to add the total sum of table 1 to Line C of table 2 to be able to display a power bi table as follows:

 

Power BI Table:

Column 1   Column 2

Line A         10

Line B         5

Line C         75 (15 + 60)

 

So the final report lines share names with the ones in table 2.

 

Any ideas on how to achieve this?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Add result of one table to specific row of another

@Sumsar Don't know what you are trying to achieve here but this will work, add a measure

 

Measure = 
SUM ( Table2[Column2] )
+
IF ( SELECTEDVALUE ( Table2[Column1] ) = "Line C", SUM( Table1[Column2] ) )

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Add result of one table to specific row of another

@Sumsar Don't know what you are trying to achieve here but this will work, add a measure

 

Measure = 
SUM ( Table2[Column2] )
+
IF ( SELECTEDVALUE ( Table2[Column1] ) = "Line C", SUM( Table1[Column2] ) )

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Community Champion
Community Champion

Re: Add result of one table to specific row of another

@Sumsar 

 

Try the below DAX measure.

 

Val = 
var selectedVal= SELECTEDVALUE(Table2[Column2])
var selectedLine= SELECTEDVALUE(Table2[Column1])
var _sum= SUM(Table1[Column2])+selectedVal
var result= SWITCH(selectedLine,"LineC",_sum,selectedVal)
return result

 

Capture.JPG

 



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂

Highlighted
Frequent Visitor

Re: Add result of one table to specific row of another

@parry2kcan't believe I did not think of this myself, but beautiful solution never the less, thanks 🙂

 

 

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors