Forum Discussion
Columns summarization disabled due to Tabluar editor
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
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
9 Replies
ryan_mayuSuper User
could you pls provide some sample data and expected output?
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.
- v-sdhruv
Community Support
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 - 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 YouHi,
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 ,
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 - 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 so other members can easily find it.
Thank You
