Adding up with SUMX mesure
Hi everybody. I have a problem whith the ading up in a sumx mesure whit a filter. I hope someone here could healp me to solv this issue. Here we go: I have a db with the Acomulative Inventory by each SKU. I have to take out the inventory at the last date of the pivote table filter. This is te data: N° Sequencia Date mov tipo MODEL SKU Mov Stock Ac. 1 25-05-2018 BUY Leter A 5 5 2 26-05-2018 BUY Leter B 6 6 3 26-05-2018 BUY Leter C 7 7 4 26-05-2018 BUY Leter D 7 7 5 27-05-2018 SALE Leter A -1 6 6 28-05-2018 SALE Leter A -1 4 7 29-05-2018 SALE Leter C -1 6 8 01-06-2018 SALE Leter A -1 3 9 01-06-2018 SALE Leter A -1 2 10 02-06-2018 SALE Leter B -2 4 11 02-06-2018 SALE Leter D -1 6 12 05-06-2018 SALE Leter C -3 3 13 07-08-2018 SALE Leter B -1 3 14 07-08-2018 SALE Leter C -1 2 15 10-06-2018 SALE Leter D -2 4 16 10-06-2018 SALE Leter D -1 3 17 10-06-2018 BUY Leter B 1 4 18 11-06-2018 VALUE Leter D 0 3 19 12-06-2018 SALE Leter D -2 1 This is the pivot table: Date MODEL SKU Stock Ac. Mayo leter A 4 B 6 C 7 D 7 TOTAL 7 Junio leter A 2 B 4 C 3 D 1 TOTAL 4 Agosto leter B 3 C 2 TOTAL 3 Total general 7 The mesure of "Stock Ac" is: =SUMX(FILTER(Table1,Table1[N° Sequencia]=MAX(Table1[N° Sequencia])),Table1[Stock Ac.]) Its gives to me the correct record by row, but the add up it's wrong. How can i get the correct subtotal and grand total? I´tried with this other measure =SUMX(FILTER(Table1,Table1[N° Sequencia]=MAX(Table1[N° Sequencia])),SUM(Table1[Stock Ac.])) But this is wrong in the record by row and also in the adding up.