Calculation group breaks summarize feature in desktop

[vgeldbr]

Has anybody experienced where setting up a  Calcuation Group in Tabular Editor causes the summarize feature to stop working in Power BI desktop? The theta symbol disappears and you are no longer able to set fields to summarize. See the screenshots. I have been able to consistently repeat this over and over. Removing the Calculation Group does not fix it. 

 

[amitchandak]

@vgeldbr , If you use Tabular edition then you will not be able to change it in desktop

[vgeldbr]

Thanks @amitchandak but this is not my concern. I know you cannot edit calculation group measures directly in PBI desktop. My point is that adding any calculation group via Tabular Editor results in the summarize function stopping working for the entire data model. See my screenshots with missing theta icon and missing options in column settings. Removing the calculation group does not restore the functionality; it appears to be permanently broken in that data model.

[v-yingjl · Accepted solution]

Hi @vgeldbr ,

It is by design. Calculation groups are not compatible with implicit measures.

It is described in the documentation that you can refer: Calculation groups 

When you enable calculation groups, Tabular Editor enables the Model option Discourage Implicit Measure.

If you remove all the calculation groups, you can restore that property to False to enable implicit measures again.

However, it is a best practice to only expose explicit measures in a Tabular model.

You can also refer: 
https://github.com/otykier/TabularEditor/wiki/Useful-script-snippets

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[usjjvr]

Thank you, I just came accross this and it was incredibly frustrating. Easy fix.

[PowerBIdevelop]

what was the solution ? I am trying to set Discourage Implicit Measures to false but for that calculation group needs to be disabled but I need the calculation groups.

[vgeldbr]

Thank you @v-yingjl , this answers the question perfectly. I did not see this in the Power BI documentation but it is in the documentation you shared.