Forum Discussion

Jarrgh's avatar
Jarrgh
Frequent Visitor
5 years ago

Calculation groups and Implicit measures

I'm implementing calcualtion groups in a PBIX model, using tabular editor, to handle time intelligence etc. which is great - saves a lot of time. But... as calc groups doesn't work with implicit mea...
Need Help
Jarrgh's avatar
Jarrgh
Frequent Visitor
5 years ago

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

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

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-snippets

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!