Forum Discussion
Helper IVCalculation group breaks summarize feature in desktop
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.
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-snippetsBest 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.
6 Replies
- amitchandak
Super User
vgeldbr , If you use Tabular edition then you will not be able to change it in desktop
vgeldbrThanks 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-yingjlCommunity Support
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-snippetsBest 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.
