Combining Filtered Columns Across Pages

[Anonymous]

Hi there, 

Super new to Power BI, so please let me know if this question has been asked before, however I have taken a good look. 

Background - Data is pulled from our practice management system in our vet hospital. Staff ask to find cases based on a term e.g. shoulder. There are a number of areas in the PMS this term could be. Staff want one list of all animals that have that term on their file.

Question - I have created a number of pages with filters, all containing the 'animal_code' column. How do I consolidate all of the filtered Animal Codes across the pages?

Example - 

Result - I would like to have all of the animal codes in one column on a new page

Please let me know if more details are required

Kelly

[amitchandak]

@Anonymous , If they are three different table,, you need to create a common table by distinct , union distinct

refer

DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

[Anonymous]

Hi there, 

Thank you for replying. I watched the second video on Power Query. I managed to create a query that combined the animal code from all of the tables. This created a single column which I converted to a table. 

It then said in the video to create a relationship between the new table and the existing ones, however I run into this issue 

Is this because I already have existing relationships between the other tables?

Thanks