Forum Discussion
Value summary and default summary change not working
- 3 years ago
Wanted to circle back microsoft support found the issue.
In attempting to mess around with calculation groups in tabular editor it changed a defaul setting in the model.
Discourage Implicit Measures in order for the Default summarization to work in power bi this must be set to false.
If you create any calculation groups it by default turns this feature off for the model and cannot be on if calculation groups are present in the model.
So the solution was to delete the Calculation Groups and change the setting by clicking on Model and Changing the True to false under Discourage Implicit Measures.
Hope this helps someone else that has run across this issue like me.
Hello this is not a SQL analysis service. It is a SQL Server set to import data. And the issue is that it was working and then something I did broke the function completely. Have a work ticket in with microsoft support and they have been working to try and figure out the issue fore a couple weeks now to no avail.
I would up just having to re create the file. Took special attention to shrinking the size of my model and the memory storage.