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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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