Merge results from two visuals

Question

Hi, I have a PBI report that has two Table visuals that I need to merge together. They each have diferent filtering. I want to move the count1 for Bradley from visual A into visual B. I have included an example of the visuals below.&nbsp;Visual A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;Visual B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;Thanks, Mark&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

daniel29195 · Answer

Anonymous&nbsp; Hello ,&nbsp;from my understanding , you want to show values from table 1 and table 2 into one table visual ..&nbsp;one way i can think of to achieve what you want, it to create a new table containing all the values you need to show .&nbsp;you can use union for this.&nbsp;&nbsp;and then you can work with DAX to calculate the intended measure base on the filter context .&nbsp;you can use.&nbsp;NB :&nbsp; the complexity of the work will depend on the complexity of the model .&nbsp;&nbsp;&nbsp;let me know if this helps.&nbsp;Best regards,&nbsp;Daniel&nbsp;

anonymous · Answer

Can I union the two visuals or do I need to create a separate table in the Data Pane from the one already being used to populating the two visuals?Second question - Is there a table created behind each visual that can be referenced and manipulated?&nbsp;&nbsp;

Forum Discussion

Merge results from two visuals