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. 

Thank you

Sunil 

  • 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!

6 Replies

    • sshah55's avatar
      sshah55
      Frequent Visitor

      Thanks Greg_Deckler for a very quick response ! I'll try it as soon as I'm in front of PowerBI desktop. 

      regards 

      Sunil 

    • sshah55's avatar
      sshah55
      Frequent Visitor

      I'm sorry Greg, I could not find that setting ...eas this in the service or desktop ? Thank you Sunil

  • Anonymous's avatar
    Anonymous
    Not applicable

    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!

    • deanhale's avatar
      deanhale
      Frequent Visitor

      This solution is outdated.  ”Model explorer and Calculation group authoring” option no longer available.

    • shraddhagupta15's avatar
      shraddhagupta15
      New Member

      Hello, Can you let me know where can I find this settings please? I have access BPA (Business Performance analytics) from D365 F&O and I am not seeing this option on Business performance analytics page.