Same column dax

[Anmolgan]

How can I write a dax that will calculate separate sums from 3 seprate tables and work with any of the one filter (all the filters in 3 tables contains same values, I want to only use 1 filter here) each of my table contains many to many relationships and sums.should change on the action of only 1 filter

[v-yuta-msft]

@Anmolgan ,

---

@Anmolgan wrote:
How can I write a dax that will calculate separate sums from 3 seprate tables and work with any of the one filter (all the filters in 3 tables contains same values, I want to only use 1 filter here) each of my table contains many to many relationships and sums.should change on the action of only 1 filter

---

Not very clear about your requirement, could you please share some sample data and give the expecte result?

Regards,

Jimmy Tao

[amitchandak]

Many to Many relations are not ideal. So check the need.

If relations are bi-directional then you can filter the table in any direction. No sure power Bi will allow that in you case.

You can create measure like across the tables

measure = sum(table1[col1]) + sum(table2[col1]) + sum(table3[col1])