Saving Calculation Groups to pbix removes sigma symbols against integer fields

[gooranga]

Hi,

I was experimenting with the new ability to add calculation groups to power bi desktop using External Tools functionality and I have noticed that when it saves the group it then removes all the sigma symbols against integer fields in th emodel so they cannot be used in visualisations on their own. They can continue to be used in measures without any problem. I don't get this when just adding measures though it's just calculation groups.

I am on the latest version of both power bi and tabular editor.

https://community.powerbi.com/t5/Desktop/Tabular-Editor-edit-and-lost-sigma-icons-against-whole-number/m-p/1242516

Below are before and after shots. Refreshing doesn't help and once this has happened I can't seem to get the sigmas back.

[otykier]

This is by design.

In order to add a calculation group to a model, the Analysis Services engine requires that the DiscourageImplicitMeasures-property on the model be set to False. Tabular Editor does this for you automatically when you add the first calculation group. Once this property is set to False, all numeric columns will no longer be treated as implicit measures by Power BI. This is perfectly fine, as the best practice is to create explicit measures anyway. By the way, these can easily be scripted with Tabular Editor.

Check out the official documentation for Calculation Groups for more information.

[marcosqlbi]

@otykier do you mean that DiscourageImplicitMeasures must be true to enable calculation groups?

[otykier]

Yes - I believe the engine throws an error if you try to add a calc group with DiscourageImplicitMeasures set to false.

[kadirkkkk]

Some visuals like Drilldown radial barchart and Impact bubble chart stop working after creating calculation groups even if i use measures.

[otykier]

@kadirkkkk see #380. Long story short: This is an issue in Power BI Desktop.