Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Why cannot see implicit measure/aggregation options?

Hi all,   Recently I realized that I cannot change the aggregation of a column (use as implicit measure) when I add that to a visual (e.g.: switch from sum to avg or median or don't summarize). Whi...
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Anonymous my pleasure. 
    Taking it one step further, that object is called 'Discourage Implicit Measures' and it's one of the properties at the model level.
    You can't edit it in PBI desktop, only through an external tool like Tabular Editor.

     


    By defulat its value is 'False'. Once you create a calculation groups it's forced to 'True'. If ever you will delete all your calculation groups you will need to connect to the model through tabular editor and switch it back to 'False' in order to gain back the implicit measure capabilty.


    Showcase Report – Contoso By SpartaBI