Forum Discussion

prill2ta's avatar
prill2ta
Advocate II
6 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.

 

Any assistance would be helpful. 

Thank you, 

 

  • 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.

9 Replies

  • 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

    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

      Yes, 

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


      Thanks for the quick response Greg !

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