Forum Discussion

sshah55's avatar
sshah55
Frequent Visitor
2 years ago
Solved

Implicit measures

Hello  can I switch off IMPLICIT measures for all numeric tables in my PowerBI file ?   I seem to remember that @PatrickLeBlanc of GuyInACube suggested this somewhere but I can't recall where.  ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sshah55 ,

     

    It's right as Greg_Deckler said.

     

    Please follow these steps:

     

    1. Before proceeding, you need to enable a feature -- File>>Options and settings>>Options>>Select "Preview features">>Select ”Model explorer and Calculation group authoring”.

     

    2. Go to the "Model" tab >> Select "Model" under the "Data" pane >> Select "Semantic model" >> Enable "Discourage implicit measures".

     

    3. Or click the Calculation group above. When trying to create a calculation group, if the "Discourage implicit measures" property is turned off, you will be prompted to open a dialog window asking you to open it to enable creation of the calculation group.

     

    By enabling this property, Power BI no longer displays summation symbols next to data columns in the Data pane, thus discouraging the creation of implicit measures. It also prevents data columns from being added directly to visuals on aggregate axes or as values. However, existing implicit measures that have been created in the visual will continue to be valid.

     

    For more information, please refer to the following documentation link:

    Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn

     

    If you have any further questions, please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!