Return a column summarize in var keyword

[neonguyen1803]

Dear community, 

I have a table to record dept of customers. Then I wrote a dax to calculate Topn dept such as below:

Dept TOPN = 
var top_n = SELECTEDVALUE('TOPCUSTOMER'[TOP], 3)

var table_1 = SUMMARIZECOLUMNS(Customer[Customer ID], "Total Dept", SUM(Customer[Dept]))

return Calculate(SUM(table_1[Total Dept]), TOPN(top_n, table_1, [Total Dept], DESC))

But at the return step, I can't find column [Total Dept] (red tex) of table_1 (created with var keyword). Please explain for me this case

Thank you

[neonguyen1803]

Ops, someone help me? 

[Greg_Deckler]

@neonguyen1803 Maybe:

Dept TOPN = 
var top_n = SELECTEDVALUE('TOPCUSTOMER'[TOP], 3)

var table_1 = SUMMARIZECOLUMNS(Customer[Customer ID], "Total Dept", SUM(Customer[Dept]))

return Calculate(SUMX(table_1,[Total Dept]), TOPN(top_n, table_1, [Total Dept], DESC))

[neonguyen1803]

Hi Greg,

I tried your solution, and can find the column but the results are wrong.

This is the total debt of all customers. The result does no change when I change Topn rank, eg. change to top3 or top 5 still get the result is 14.18bn