Forum Discussion
Calculation groups and Implicit measures
Hi Kelly
Thank you for the link - it doesn't excatly cover my question, but i'm afraid i haven't been clear enough.
It is clear that tabular editor forces the setting "Discourage Implicit Measures = true", when a model uses calculation groups(CGs), this effectively disables creation of new implicit measures.
The documentation states that CGs are incompatible with implicit measures, but actually Implicit measures work just fine, they are just uaffected by CGs (which ofcourse is important to be aware of)
My question is if it is in any way possible to overrule tabular editor, and reenable implict measures while having CGs
Hi Jarrgh ,
Have you tried to modify it in Tabular editor?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi Kelly
yes i tried but it won't allow me to modify the setting (see below)
what i'm looking for is a way to override the restriction directly in tabular editor or in the pbix model
Hi Jarrgh ,
Can you transfer the measures to calculated columns and try again?
I checked below reference again and found that it is only supported in Tabular model,if in power bi,it will be disabled:
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-snippetsBest Regards,
KellyDid I answer your question? Mark my post as a solution!