Discourage implicit measures” toggle missing

[mhsksh]

Power BI Desktop (Import/DirectQuery, not Live). In one PBIX, numeric columns don’t show the Σ icon and can’t be placed in Values—only work if I create explicit measures. In Model view I can’t find the “Discourage implicit measures” toggle anywhere (Properties pane only shows table/visual properties). Same model loaded into a new PBIX works fine, so this seems file-scoped/corrupted. I’ve confirmed columns are Decimal number with Default summarization = Sum, cleared cache, refreshed, reset panes, rebuilt visuals—no change. Any idea how to re-enable implicit measures or reset the model flag in this PBIX without rebuilding the report? Thanks!
And just to add one point, when I open the data in new PBIX, it works but I need it in my current dashboard

[Ahmed-Elfeel · Accepted solution]

Hi @mhsksh,

This Problem occurred with one of my team before...So here is some steps might work with you:

1-Force Reset via Tabular Editor:

• Download Tabular Editor (free version) if you don't have it

• Open your PBIX file in Tabular Editor

• Navigate to your data model → right-click the model → select Properties

• Look for DiscourageImplicitMeasures property

• Change it from true to false
• Save and close Tabular Editor, then reopen PBIX

If you not like this solution try this approach (Same thing but in another way):

• Close Power BI Desktop

• Make a backup of your PBIX file

• Rename the file extension from .pbix to .zip

• Extract the contents

• Locate and open DataModelSchema file in a text editor

• Search for discourageImplicitMeasures

• Change the value from true to false

I hope i could help you ☺️❤️

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

[gvlado]

You can see answer , hope will help, here
Solved: Calculation groups and implicit measures - Microsoft Fabric Community

[mhsksh]

Thank you so much @danextian  and @Ahmed-Elfeel 
Finally it solved

[mhsksh]

Hi everyone,
Thanks for your help. I have one more question

Your solution worked, but I created a field parameter in Power BI to switch between different numeric columns in my fact table, instead of dragging each value separately. When I drag the same fields directly into the Matrix, the values appear correctly. However, when I use the field parameter, the values don’t display properly.

Why doesn’t the field parameter show the values, even though implicit measures are enabled and the summarization is set to sum?

[danextian · Accepted solution]

Hi @mhsksh 

A calculation group was created in the model, which triggers a warning that implicit measures are discouraged. Removing the calculation group won’t revert this behavior, but you can adjust it in Tabular Editor.

[Ahmed-Elfeel · Accepted solution]

Hi @mhsksh,

This Problem occurred with one of my team before...So here is some steps might work with you:

1-Force Reset via Tabular Editor:

• Download Tabular Editor (free version) if you don't have it

• Open your PBIX file in Tabular Editor

• Navigate to your data model → right-click the model → select Properties

• Look for DiscourageImplicitMeasures property

• Change it from true to false
• Save and close Tabular Editor, then reopen PBIX

If you not like this solution try this approach (Same thing but in another way):

• Close Power BI Desktop

• Make a backup of your PBIX file

• Rename the file extension from .pbix to .zip

• Extract the contents

• Locate and open DataModelSchema file in a text editor

• Search for discourageImplicitMeasures

• Change the value from true to false

I hope i could help you ☺️❤️

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.