cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Archonik
Frequent Visitor

Tabular Editor - Calculation groups

Hi Team,

 

When I started to use Calculation groups and enabeled Tabular Editor + created one calculation group in my data model, I started to experience one issue.

 

Prior any implementation of calculation groups, I could use default count,distinct count, etc. calculation when I drag and drop it to my canvas.

 

Archonik_1-1597044566379.png

 

After creating one calculation group and using it in my model, I am not able to use any default calculation anymore. Please see the printscreen of the same drop down for same column bellow. The same is applicable for any other column in data model.

 

Archonik_0-1597044480051.png

 

Thanks for your help,

 

J.

 

2 ACCEPTED SOLUTIONS

It is not a bug, it is by design.

Calculation groups are not compatible with implicit measures.

It is described in the documentation, too:

https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...

 

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

View solution in original post

7 REPLIES 7

It is not a bug, it is by design.

Calculation groups are not compatible with implicit measures.

It is described in the documentation, too:

https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...

 

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

View solution in original post

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 

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.

v-yingjl
Community Support
Community Support

Hi @Archonik ,

Based on your description, I can reproduce it in my environment. Seems like a normal phenomenon if the there has sigma field in the table after creating a calculation group but not certain. Need further confirmation whether it is a bug or how it works. I would suggest you to create a support ticket for faster help if it is urgent for you.

Support Ticket.gif

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

amitchandak
Super User IV
Super User IV

@Archonik , if these are measures you will not have the option for aggregations. You only get this option for columns



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@amitchandak, unfortunatelly the column which I specified on the print screen is really column and not meausre.

 

Please see the print screen of the column from the table bellow.

 

Archonik_0-1597071652651.png

 

The problem which was specified in my first post influence any column which I try to use in my calculations.

 

The common factor for this issue is installed tabular editor and used calculated group in the Data model.

 

Thanks,


J.

 

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.