Integer Columns Not Summarizing Unless Inserted Into Measure

[prill2ta]

Hello, 

All of my integer columns are not summing to their default summarization type... and they are not letting me sum them at all unless I insert the field into a measure. Pictures attached.

Any assistance would be helpful. 

Thank you, 

[prill2ta · Accepted solution]

@Greg_Deckler and @amitchandak 

I have solved the issue. 

I have Calculation groups in my model through Tabular Editor and it automatically set my 'Discourage Implicit Measures' setting to 'True' when those were uploaded. 

I have since toggled it to 'False' and all seems well so far. 

I will update this thread if there are any persisting issues to note.

[Greg_Deckler]

@prill2ta - Yeah, never would have guessed that one! 🙂

[amitchandak]

@prill2ta , can you show the column properties. This seems like what happens with the measure. Or you have categorised it under some wrong category

[prill2ta]

Here is a Picture of my Properties. @amitchandak 

This is happening for every column in my report. Not just one.

[amitchandak]

@prill2ta , is it a live connection. Did not notice anything like this with August release.

if it not a live connection and you are on latest release check or log an issue at - https://community.powerbi.com/t5/Issues/idb-p/Issues

[prill2ta]

This is my Import Model. 

There are models that have Live Connection to this one in the Service. But this is Import. 

I do have the August Update.

[Greg_Deckler]

@prill2ta - Are you certain that they are set to a data type of Whole number or decimal? Sometimes DAX is tricky in that it auto-converts data types depending upon need.

[prill2ta]

Yes, 

I even went back into Power Query and manually changed them just to be sure.

Thanks for the quick response @Greg !