Forum Discussion

mhsksh's avatar
mhsksh
Regular Visitor
1 year ago
Solved

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 t...
  • Ahmed-Elfeel's avatar
    1 year ago

    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.

     

  • danextian's avatar
    1 year ago

    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.