Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
prill2ta
Advocate II
Advocate II

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, 

 

CostAmt1.pngCostAmt2.png

1 ACCEPTED SOLUTION
prill2ta
Advocate II
Advocate II

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

View solution in original post

9 REPLIES 9
prill2ta
Advocate II
Advocate II

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

Hello, prill2ta
You save my day !!!! 

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super 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

Here is a Picture of my Properties. @amitchandak 

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

CostAmt3.png

@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

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
Super User
Super User

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Yes, 

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


Thanks for the quick response @Greg !

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.