Forum Discussion

VarcharBI's avatar
VarcharBI
Frequent Visitor
5 years ago
Solved

Tabular Editor Scripting - "Do Not Summarize"

Hi All,

Trying to create a Custom Script under Advanced Scripting in the Tabular Editor to Set Column Summarization to "Do Not Summarise" for all selected columns.
The code I have is as follows:

 

foreach(var c in Selected.Columns)
{
    c.SummarizeBy = "none";
}

 

However I am getting a data type error msg as follows:
CS0029 - cannot implicitly convert type "string" to TabularEditor.TOMWrapper.AggregateFunction

Any assistance to get this working will be much appreciated 🙂

Need Help
  • VarcharBI's avatar
    VarcharBI
    5 years ago

    Many many thanks to dotykier - the owner and originator of the Tabular Editor... 😀

    foreach(var c in Selected.Columns)
{
    c.SummarizeBy = AggregateFunction.None;
}

     

3 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    Hi VarcharBI ,

     

    Implicit column aggregations in Power BI are not supported for models with calculation groups. Currently, if DiscourageImplicitMeasures property is set to false (default), aggregation options appear, however they cannot be applied. If DiscourageImplicitMeasures is set to true, aggregation options do not appear.


    https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#limitations 

     

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

    • VarcharBI's avatar
      VarcharBI
      Frequent Visitor
      5 years ago


      Hi Liang - and thanks for responding...

      That said I don't understand why or whether this answers the question... in so far as... all I am trying to do is to bypass a manual process in the Desktop of setting a Column attribute from Sum to Do Not Summarize using an Advanced Script in the Tabular Editor... and I get the same error whether I am connected to a model with or without Calculation Groups.

  • VarcharBI's avatar
    VarcharBI
    Frequent Visitor
    5 years ago

    Many many thanks to dotykier - the owner and originator of the Tabular Editor... 😀

    foreach(var c in Selected.Columns)
{
    c.SummarizeBy = AggregateFunction.None;
}