Forum Discussion
Tabular Editor - Calculation groups
It is not a bug, it is by design.
Calculation groups are not compatible with implicit measures.
It is described in the documentation, too:
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.
If you use Tabular Editor, you can find macros to quickly create measures from numeric columns:
https://github.com/otykier/TabularEditor/wiki/Useful-script-snippets
Most Valuable ProfessionalIt is not a bug, it is by design.
Calculation groups are not compatible with implicit measures.
It is described in the documentation, too:
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.
If you use Tabular Editor, you can find macros to quickly create measures from numeric columns:
https://github.com/otykier/TabularEditor/wiki/Useful-script-snippets
Wait, why?
Pardon my ignorance, but I find implicit measures genuinely assist me in assessing the precise filters and calculations applied in a visual. You mentioned in your "7 Reasons DAX is not easy" video that as a functional language, it can be difficult to assess the execution sequence of DAX code. It seems like the GUI experience afforded by implicit measures provides an intuitive and simple means of assessing execution order.
Personally, I wish could convert cards (and possibly other visuals) with their associated filters directly to DAX code in a single click, as is possible with the SQL query view available in Access.
Hi Marco,
Thank you very much for you detail explanation of the designed behaviour.
Would you be please so kind to just add few print screens how to restore the property to False in order to get the implicit measure working again?
Thank you,J.
- marcorusso
i just ran into this issue myself this morning when trying to modify a report with a basic mom and yoy calculation group.
gald i found this post by googling error: DiscourageImplicitMeasures
thank you for helping me understand this a bit more in tabEd
