Forum Discussion
Discourage implicit measures” toggle missing
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
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.
5 Replies
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.Thank you so much danextian and Ahmed-Elfeel
Finally it solvedHi everyone,
Thanks for your help. I have one more questionYour 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?
You can see answer , hope will help, here
Solved: Calculation groups and implicit measures - Microsoft Fabric Community
