Columns summarization disabled due to Tabluar editor

[kishordute]

Need help , have used tabluar editor long back on one of by workbook and it disabled aggrigation of columns. I had created a custom table. please assist

[v-sdhruv]

Hi @kishordute ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please Accept it as a solution  so other members can easily find it.
Thank You

[v-sdhruv]

Hi @kishordute ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @kishordute ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv · Accepted solution]

Hi @kishordute ,

1.Since aggregation is only enabled for numeric fields, can you check the the data type is numeric?
2. If this alo doesnt work, try this in your editor-

foreach (var col in Model.AllColumns)
{
if (!col.IsHidden && col.DataType == DataType.Int64)
{
col.SummarizeBy = AggregateFunction.Sum;
}
}

3. Else you can duplicate the column and give it a different name and make sure its numeric and then perform aggregation.

Hope this helps!
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @kishordute ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[kishordute]

Hi,

Sorry for the late reply , have cheked and IsHidden= False and IsSummarizeBy= Default is set have change it to sum as well but it doesn't work. Do you have any other suggession

[v-sdhruv]

Hi @kishordute ,
It sounds like when you used Tabular Editor, you may have changed a setting or property that disabled aggregation (i.e., summarization like SUM, AVG) on certain columns in Power BI. This can happen if you modified the "IsSummarizeBy" or "IsHidden" properties in the model, especially for numeric columns.
If your columns are calculated columns or non-numeric, Power BI may automatically disable aggregation. Ensure the column data type supports summarization (like Whole Number or Decimal).

If you're unsure which column is affected, you can use this script in Tabular Editor to find all columns with SummarizeBy=None

foreach (var col in Model.AllColumns)
{
if (col.SummarizeBy == AggregateFunction.None)
{
Console.WriteLine($"{col.DaxObjectFullName} - SummarizeBy: None");
}
}

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank You

[kishordute]

It's more like have made some setting in tabluar editor addin of Power BI due to which my database columns summarization option is disabled. 

[ryan_mayu]

could you pls provide some sample data and expected output?