Forum Discussion
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,
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
- prill2taAdvocate II
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_DecklerCommunity Champion
prill2ta - Yeah, never would have guessed that one! 🙂
- odumnaHelper I
Hello, prill2ta
You save my day !!!!
- Greg_DecklerCommunity 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.
- amitchandakSuper User
prill2ta , can you show the column properties. This seems like what happens with the measure. Or you have categorised it under some wrong category
- prill2taAdvocate II
Here is a Picture of my Properties. amitchandak
This is happening for every column in my report. Not just one.- amitchandakSuper User
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