Forum Discussion
Creating a calculation group in Tabular Editor disables the format dropdown in Measure Tools
Is this also the reason why none of the columns summarized anymore? All numeric columns are missing the sigmas and I can't even choose to sum those with down arrow in values section. All format options are availabe in ribbon but summarization just won't happened.
In a workaround I can use older version of the file, creates the visual with sums there and copying the visual into new file. The sums remains and everything works fine. And also, it is not very good practise to use columns straight so I normally use measures everywhere so the problem is not so huge. But in debugging purposes it is very handy to have the summarizing possibility and because of that, I really like if this will be fixed also.
I also have this issue and find it annoying.
cheers
I have also found that removing all custom format strings from calculation groups does not fix anything so once you go there, theres no going back. The only way I have found to fix the issue is to delete all calculation groups and start over. ✌
I've also been struggling with this since the External Tool integration was announced.
Here's how I can reproduce the issue:
1) Create a new PBI file in Desktop
2) Import data
3) Create a calculation group and 2 calculation items via Tabular Editor
4) Save the changes, and now measure formatting in Power BI Desktop is broken.
Here's a gif of what happens to the formatting features after these steps. Note that the format string changes when I use the format buttons, but I cannot set the format string directly nor can I choose "Whole Number" from the usual drop down. Also note that the visual does not refresh and update when I change the formatting; it only refreshes when I change the measure name.
tenfingers, I can "fix" my PBIX by deleting the Calculation Group and then disabling Discourage Implicit Measures on the Model node in Tabular Editor.
If I only create 1 Calcuation Item that returns SelectedMeasure() then this problem doesn't seem to happen. When I add a second Item that returns AverageX, then it does. Deleting the 2nd item does not make this problem go away. I tried having every Item in the Calc Group return the same data type, whether double or String, the problem still happens.
I am not using Format String Expression on any Calculation Items.
This is happening to me. Does anyone know when this is expect to be fixed?
Dan
