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
pheller
Regular Visitor

How-to turn off summarization on all table columns and no implicit measures on the visualizations?

How-to configure turning off summarization on all table columns of the model?  In addition,configure turning off implicit measures on the visualizations as the default?

 

This would allow by exception setting the summarization on the column or changing a the column in the visualization to an implicit measure.   

 

Shouldn't all measures be created explicitly? 

 

  1. Step 1 all of the columns are set manually to Don't Summarize.  Using EmployeeID as an example
  2. Step 2 Dragging EmployeeID to the table immediately changes it to an implicit count when I just wanted to show the EmployeeID

 

pb.jpg

5 REPLIES 5
v-lionel-msft
Community Support
Community Support

Hi @pheller ,

 

For numeric fields, PBI Desktop will automatically aggregate, you just cancel it manually.

v-lionel-msft_0-1599099760608.png

Why the Default Summarization Property in Power BI is So Important 

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@pheller , Under the model tab, You can click on columns under advance option you have Summarize by. You can select multiple column using ctrl or shift and can change them together

Advance Property in Model.png

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
SteveCampbell
Memorable Member
Memorable Member

First, make sure you have the latest version of Tabular Editor downloaded.

 

Next, restart Power BI and open your file.

Click External Tools and select Tabular Editor.

 

Open Advanced Scripting and paste the following code:

foreach (var c in Model.AllColumns)
{c.SummarizeBy = AggregateFunction.None ;}

 

Save the tabular editor file back the the database (ctrl-S)

Return to Power BI and Refresh your model.



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



Thanks this worked for me 🙂

This is excellent in terms of achieving the default value of "do not summarize" using the Tabular Editor.

You need a way to turn off summary in the visualization to avoid implicit measures as default. They should be by exception (turning them on manually) and eventually replacing them with explicit measures.

Thank you for your suggestion. I used Google's translator to respond in Spanish.

English:

This is excellent as far as accomplishing the default value of "do not summarize" using the Tabular Editor.

Need a way to turn off summarize in the visualization to avoid implicit measures as the default. They should be by exception (manually turning them on) and eventually replacing them with explicit measures.

Thank your suggestion. I used google translate to respond in Spanish.

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.