Forum Discussion

TE's avatar
TE
Helper I
1 year ago
Solved

Composite model Direct query columns cannot be summarized

Hi!

 

We have a composite Power BI model which is mainly built by direct query Microsoft SQL data tables. 

Previously everything has worked fine, but suddenly now aggregating columns is not working. So even if a value can be summarized and is already summarized in a report in Power BI service (for example a column is sum/average in a report), now it cannot be changed and cannot be added again as a value.  

 

Below is a snapshot of what i looks like now:

 

 

 

Any ideas why it's not working anymore and how it can be fixed?

 

Thanks!

 

 

Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi TE 

     

    You will need to use Tabular Editor and set Discourage Implicit Measures to false.

     

  • TE's avatar
    TE
    1 year ago

    Thanks! I didn't actually need Tabular Editor and was able to make the change in Power BI desktop after I deleted the calculation group. 

5 Replies

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi TE 

     

    Did you by chance create a calculation group? Doing so discouranges implicit measures.

  • TE's avatar
    TE
    Helper I
    1 year ago

    Thanks for the quick response danextian ! We have a couple of users modifing this report. It does look like my colleague has created a calculation group by mistake. I'm not that familiar with calculation groups, is there a way to turn delete these and turn on implicit measures?

    • danextian's avatar
      danextian
      Super User
      1 year ago

      Hi TE 

       

      You will need to use Tabular Editor and set Discourage Implicit Measures to false.

       

      • TE's avatar
        TE
        Helper I
        1 year ago

        Thanks! I didn't actually need Tabular Editor and was able to make the change in Power BI desktop after I deleted the calculation group. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi TE 

     

    Did danextian reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.

     

    Best regards,

    Adamk Kong