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

[pheller]

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

[v-lionel-msft]

Hi @pheller ,

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

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]

@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

[SteveCampbell]

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.

[Mark_Timson]

Thanks this worked for me 🙂

[pheller]

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.