Variable in column name in summarize table

[Anonymous]

I am creating a calculated table by summarizing date, country, branch and sales amount from Table Sales

Branch_Sales_calc =

var branch =  'Parameter'[Branch]  -- value is from query parameter

RETURN SUMMARIZE(

'Sales','Sales'[Date], 'Sales'[Country], "BranchName",SUMX(FILTER('Sales','Sales'[Branch]=branch) ,'Sales'[Amount]))
)

If I change the column name "BranchName" to variable branch I get the error - Function SUMMARIZE expects a column name as argument number 4

Is it possible to have column name based on query parameter or any dynamic value?

[amitchandak]

@Anonymous , I doubt you can use a slicer value or parameter in a new table creation

also try changing var like and try

var branch =  max('Parameter'[Branch] )

[Anonymous]

I have tried, it does not work. 

[v-jingzhang · Accepted solution]

@Anonymous Currently it is not supported to change the column name dynamically with the parameter.

As a workaround, I suggest using fixed "Sales" or "Total Sales" as the name of this column to indicate what this column's data describes. Then format the visual's title conditionally with the field 'Parameter'[Branch] to let users know which branch this data represents for.

Kindly let me know if this helps.

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[mahoneypat]

Oh.  You can't use a variable where "BranchName" is.  Why is that needed?  Why not use a fixed name that reflects what is in that column like "TotalSales"?  If needed, you could add another column to your table that has the branch name on every row.

Regards,

Pat

[Anonymous]

The report I want to build needs a column name on matrix table that based on user selection. That is why I need a dynamic column name

[mahoneypat]

Is Parameter a text value?  Or is it a 1-row/1-column table?  If a table, you need to aggregate it with MIN('Parameter'[branch]) for example.

Regards,

Pat

[Anonymous]

Yes, it is a 1-row/1-column table, text value, I have tried aggregation MIN butstill get the same error - Function SUMMARIZE expects a column name as argument number 4.