Forum Discussion

prill2ta's avatar
prill2ta
Advocate II
5 years ago
Solved

Integer Columns Not Summarizing Unless Inserted Into Measure

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.  ...
Need Help
  • prill2ta's avatar
    prill2ta
    5 years ago

    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's avatar
Greg_Deckler
Community Champion
5 years ago

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's avatar
prill2ta
Advocate II
5 years ago

Yes, 

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


Thanks for the quick response Greg !