How to remove Tabular editor from Model ( enable implicit measures, removing calculation groups)

[Rygaard]

How to remove Tabular editor from Model ( enable implicit measures, removing calculation groups)

This was remarkable easy to do, but incrediable hard to find out how to if you dont know.

I made some Calculations groups in TabularEditor - without knowing that this would Disable implicit measuers ( using an autosum directly in a matrix or table)

implicit measueres is a measure you did not make

Explicit measuere is a measuere you typede like:

CALCULATE(SUM('Posted_Sales'[Invoiced_Amount_LCY]))

So to get rid of the this so you can use implicit measuers again you nedde to  : 

1. Delete all calculation groups from the model (you can delete them in Power BI Desktop)
2. Load the model into Tabular editeor, Click Model and then under  Options find "discourage Implicit Measuers" and toggle it to false.

on picture

1. load model into tabular editor
2. click model
3. toggel Discurage Implicit Measuers

[JillianK]

Thank you! This is exactly what I was looking for!

[LozzyLeopard]

I have the same issue but I am using Fabrci and have no idea how to load into Tabular Editor.  I am unclear why this cannot be undone in Fabric when it was originally done in Fabric?  There appears to be no Properties on the semantic model in Fabric.

[foodd]

Hello @LozzyLeopard ,  thanks for reaching out to the Fabric Community Forum. Since the original post was informational and over a year old, please create a new post for your questions instead of replying to the existing one. Rest assured, our community is here to support you, and this approach will help ensure that your question is seen by more people and answered more quickly.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

[Anonymous]

HI @Rygaard,

Thanks for sharing these, I think they will be helpful if others have similar requirements.

Regards,

Xiaoxin Sheng