Forum Discussion
Helper IIISummarization Options Not Showing
Hello, I am running into an issue on a PBIX file where my summarization options are not showing when I add a column to a table visual. In the column dropdown, all I see is below:
On another version of the same report, I try the same field and get all of the options.
The only thing I can think of that could have caused this is on the first file, I tried to create a calculation group in Tabular Editor (but later deleted it). I've read that this can be the cause of my issue, but I'm not sure how to disable the option. I already deleted the calculation group from Tabular Editor but the issue still persists. I checked the options and settings between the two reports and they are the same, is there something that I am missing?
Thanks!
Hi bernate
To fix this, the setting you need to switch off is "Discourage Implicit Measures".
You can turn this off in Model View > Model Explorer. See here.
This property is automatically turned on when the first calculation group is created, but must be turned off manually, which can only be done if there are no calculation groups remaining.Does that help fix the issue?
3 Replies
- OwenAuger
Super User
Hi bernate
To fix this, the setting you need to switch off is "Discourage Implicit Measures".
You can turn this off in Model View > Model Explorer. See here.
This property is automatically turned on when the first calculation group is created, but must be turned off manually, which can only be done if there are no calculation groups remaining.Does that help fix the issue?
bernateHi Owen, that worked perfectly. Thank you!
MichaelSamiotisResolver I
I would check the data type of the column first. If it is a number, the option should be there. If this doesn't work, try to remove and put back again the field, I've come across some of those glitches.