cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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 

Anonymous
Not applicable

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.

abc.png

v-yingjl
Community Support
Community Support

Hi @Anonymous ,

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
Super User

@Anonymous , 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 !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!
Anonymous
Not applicable

@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
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors