Where have the summarize / don't summarize options gone?

[AlanPD]

In one of my datasets, I have lost the ability to select how the value should be summersied or not summerised.

These are the options I get working with the old dataset:

But for the same field in the same visual, from the new dataset the options are not avaiable!

Does anyone know why these options would be hidden?

[AlanPD · Accepted solution]

So the issue was the Discourage Implicit Measures was set to True. This flag is set when you add a Calculation Group.  I couldn't find a way to uncheck this in Power BI Desktop, but it is easy enough in Tabular Editor.

Unchecking the flag seems to remove the calcualation groups and I can see why there may be a limitation in some scenarios, but in my case I was only using the calculation groups to apply different filter criteria, so thay had nothing to do with the summerisations. Not a great implementation of the Calculation Group feature Microsoft!

[AlanPD]

Even when the default summarisation is set to SUM the column is not being Summed on the visuals.  As far as I have found this is an issue for all columns and all visuals, but only in this dataset!

[Anonymous]

Hi,@AlanPD ,I am glad to help you.
Hello,@anmolmalviya05 ,thanks for your concern about this issue.And I would like to share some additional solutions below.
According to your description, your newly created dataset has the following problem: all columns cannot be aggregated (the option to aggregate is gone)
I think there may be some problems with your new dataset itself, as you suspected. Please check if the datatype of the problematic field has been changed incorrectly, because the aggregation functions available in power bi are different for different types of fields!
I suggest you to select some of the problematic fields in the dataset and create some new calculated tables to verify if there is a problem with the dataset itself.
If possible, please provide me with the pbix file that does not contain sensitive data and has the current problem, this will be very helpful in solving your problem.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlanPD]

Hi @Anonymous,

Thanks for you reply. The summerisation was previously working properly however at some point during the development it get broken! There are fields in older visuals which are still set to SUM and those visuals still work but the option to change the sumerisation is also not visable on those columns any more!

Here is a cut down version of the dataset, however it is still a bit of a beast I'm afraid!

[anmolmalviya05]

Hi @AlanPD  , Hope you are doing good! 

Please check that the column summarisation is set to Don't Summarize.

You can do that from data view, Select the column and on the top ribbon you will se the option for Summarization

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!