topic Implicit measures in DAX Commands and Tips

Implicit measures

sshah55 — Mon, 19 Feb 2024 17:38:29 GMT

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

Re: Implicit measures

Greg_Deckler — Mon, 19 Feb 2024 17:44:54 GMT

sshah55 In the Model tab:

Re: Implicit measures

sshah55 — Mon, 19 Feb 2024 17:51:19 GMT

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

regards

Sunil

Re: Implicit measures

sshah55 — Sun, 25 Feb 2024 19:02:10 GMT

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

Re: Implicit measures

Anonymous — Mon, 26 Feb 2024 10:05:38 GMT

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!

Re: Implicit measures

deanhale — Mon, 05 May 2025 20:15:13 GMT

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

Re: Implicit measures

shraddhagupta15 — Thu, 17 Jul 2025 14:24:07 GMT

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.