Summarization missing after adding a calculation group

[dbmahn]

Hey, after adding a calculation group in Tabular Editor, the (default) summarization function is missing.

without calculation group in my model:

after adding an empty calculation group:

Removing the calculation group does not bring back the summarization option.

Is there a reason for this behavior?

[molegris]

Hi @dbmahn ,

It works like this by design.  Calculation groups are not compatible with implicit measures (aka default summarization).  When you create a calculation group, a model's property called Discourage implicit measure is set to TRUE.

You can either remove the calculation group and set this parameter back to FALSE or create an explicite measure for every numeric value you want to expose.  Ex. myExplicitMeasure = SUM( 'table'[Value] )

Hope that helps.

--mo

[kadirkkkk]

And so poor that some visuals stop working after this setting (after creating calculation groups)

Visual examples: Drilldown radial barchart, Impact bubble chart

[Anonymous]

Hi @dbmahn,

How did you do these grouping operations? In power bi desktop side or external tools?
I do not so recommend you directly connect to the power bi data model to edit. These operations may break raw properties/relationships, so that power bi desktop not able to recognize changed fields and properties.
Regards,

Xiaoxin Sheng

[dbmahn]

"How did you do these grouping operations?" Tabular Editor

[Anonymous]

Hi @dbmahn,

It sounds like the issue appear after you edit with external tools, I'd like to suggest you enter the query editor and duplicate the raw query table, save and generate the new data model table then check if this issue does not appear on the new query table.

If this is a case, you can remove the old table and use a new table instead.

Regards,

Xiaoxin Sheng