How to write dax to select 1 column from all 3 tables?

[Anmolgan]

I have 3 tables and I am having many to many relationships in between each of the tables, now I am calculating sum from all the three separate tables, sum should separate for each of the three tables
Now I use 2 filters inorder to.filter out my 3, sums, but problem here is I have those 2 same columns present in each of the 3, table's whenever i use filter from any of the one table it only filters out my respective sums and not the different sums from all the 3 tables, my question is how can I write a dax to calculate the sum for each different tables and all the sums should get filtered out with respect to only 1 filter

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.

My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Anmolgan]

@amitchandak how can i provide sample information to you? can you share your email id or provide a link where can I post.