Forum Discussion
azaterol
Helper V
Helper VAdd amount from other table to calculated column - Need Help in DAX
Hello everyone, I have given two tables. Invoice table and an order table. These two tables are linked to each other via the invoice number. There is therefore a 1:n relationship. I wo...
Hi,
Create a single column table with all unique DocNr (Table name is Docs). Create a relationship (Many to One and Single) from the 2 tables to the Docs table. To your visual, drag DocNr from the Docs table. Write this measure
Total = sum(invoice[Invoice X]) + sum(Order[calculated column])
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
Create a single column table with all unique DocNr (Table name is Docs). Create a relationship (Many to One and Single) from the 2 tables to the Docs table. To your visual, drag DocNr from the Docs table. Write this measure
Total = sum(invoice[Invoice X]) + sum(Order[calculated column])
Hope this helps.