Forum Discussion
Solved
Sum by ID
Hi guys! Can anybody help me? I have a table with my sales (Vendas table). These sales can be received in installments (Column Qtde de Parcelas) I have another Receipts table (T...
Why don't you switch to a DAX Measure? If I were you I'd proceed this way:
- Start with setting up the relationship on Stone ID (apparenty 1 to Many from Vendas to Recebimientos)
- In a table (or matrix) visual, add:- Stone ID
- Total = SUM(Vendas[Valor Bruto])
- Total_Paid = SUM(Recebimientos[Valor Bruto])
- Open_Amount = Total - Total_Paid
Why don't you switch to a DAX Measure? If I were you I'd proceed this way:
- Start with setting up the relationship on Stone ID (apparenty 1 to Many from Vendas to Recebimientos)
- In a table (or matrix) visual, add:
- Stone ID
- Total = SUM(Vendas[Valor Bruto])
- Total_Paid = SUM(Recebimientos[Valor Bruto])
- Open_Amount = Total - Total_Paid
JulienZH I made it this way and it worked really well. Thanks