Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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,
Solved! Go to 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 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! 🙂
@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.
@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.
@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.
Yes,
I even went back into Power Query and manually changed them just to be sure.
Thanks for the quick response @Greg !
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
154 | |
120 | |
73 | |
73 | |
63 |