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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

html:
Carousel MBAS ARun Part 1 768x460

MBAS 2021

Join Arun Ulagaratchagan and the Power BI team at MBAS! #MSBizAppsSummit #CommunityRocks

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!