Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
DPatkos
Helper I
Helper I

Why cannot see implicit measure/aggregation options?

Hi all,

 

Recently I realized that I cannot change the aggregation of a column (use as implicit measure) when I add that to a visual (e.g.: switch from sum to avg or median or don't summarize). Which is not a big thing as usually I use explicit measure, but sometimes I like to have this option for quickly testing something.

 

It really bothered me so I tested it and it works fine if I open a new Power BI document and when I add a few dummy rows, it works as intended (I also have the summa sign next to the value column in the columns' list).

DPatkos_1-1652790578119.pngDPatkos_2-1652790600400.png

 

But when I'm trying to do the same with my current PBIX it's not working.

DPatkos_0-1652790521506.png

DPatkos_3-1652790700511.png

 

 

I guess I must have messed up something with the settings but couldn't figure out what. Do you have any idea/suggestion?

Thanks!

2 ACCEPTED SOLUTIONS
SpartaBI
Community Champion
Community Champion

@DPatkos you created a calcualtion group. This switch off option of impicit measures.
You can't have both.


2022-05-09 22_36_04-Power BI Workspace Datasets License Permissions - Microsoft Power BI Community.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png  SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

SpartaBI
Community Champion
Community Champion

@DPatkos my pleasure. 
Taking it one step further, that object is called 'Discourage Implicit Measures' and it's one of the properties at the model level.
You can't edit it in PBI desktop, only through an external tool like Tabular Editor.

SpartaBI_0-1652791493057.png

 


By defulat its value is 'False'. Once you create a calculation groups it's forced to 'True'. If ever you will delete all your calculation groups you will need to connect to the model through tabular editor and switch it back to 'False' in order to gain back the implicit measure capabilty.


2022-05-09 22_36_04-Power BI Workspace Datasets License Permissions - Microsoft Power BI Community.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png  SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

6 REPLIES 6
gpoelmans
Frequent Visitor

Well explained! It was useful. 

SpartaBI
Community Champion
Community Champion

@DPatkos you created a calcualtion group. This switch off option of impicit measures.
You can't have both.


2022-05-09 22_36_04-Power BI Workspace Datasets License Permissions - Microsoft Power BI Community.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png  SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

That explains this very much, thank you! I didn't know about this about calc.groups.

SpartaBI
Community Champion
Community Champion

@DPatkos my pleasure. 
Taking it one step further, that object is called 'Discourage Implicit Measures' and it's one of the properties at the model level.
You can't edit it in PBI desktop, only through an external tool like Tabular Editor.

SpartaBI_0-1652791493057.png

 


By defulat its value is 'False'. Once you create a calculation groups it's forced to 'True'. If ever you will delete all your calculation groups you will need to connect to the model through tabular editor and switch it back to 'False' in order to gain back the implicit measure capabilty.


2022-05-09 22_36_04-Power BI Workspace Datasets License Permissions - Microsoft Power BI Community.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png  SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

Again, thanks for the helkp and explanation @SpartaBI . I'll keep this in mind!

Edit: I accept this as solution as well, as the 2 replies toghter can be a huge help for less experienced Tablar Editor users.

SpartaBI
Community Champion
Community Champion

@DPatkos you welcome 🙂

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.