I need help in summing up the values from a calculated Table. Please check the DAX

[sathishsam]

I need help in summing up the values from a calculated Table. Please check the DAX

Tbl_Trend =
VAR A = SELECTCOLUMNS(FILTER(TableA, TableA[Date] = MAX(TableA[Date])), "Country", MAXX(RELATEDTABLE(TableB),TAbleB[Country]), "Sales", TableA[Sales])

VAR B = SUMMARIZE(A, [Country], SUM(Sales))

I am getting an error on SUM(Sales)

[amitchandak · Accepted solution]

@sathishsam , If A nad B are Realated

Sumamrize(FILTER(TableA, TableA[Date] = MAX(TableA[Date])), TableB[Country], "Sales", Sum(TableA[Sales])  )

You can also explore Groupby

example here

https://amitchandak.medium.com/power-bi-power-query-vs-dax-append-and-summarize-data-233f173d0839

[sathishsam]

WOW i didnt know this was this simple.. thank you so much @amitchandak