Forum Discussion

Narendra's avatar
Narendra
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
Solved

Column Names contains prefix as Sum Of

Hi All,   I have taken table as a  visualization in my Power Bi Desktop file. In this table I required total for all value fields , for this I have selected all value columns type as Sum but in thi...
Need Help
  • djnww's avatar
    djnww
    10 years ago

    Hi Narenda,

     

    The 'Sum of' will occur when you apply an aggregation which is different to the field/column's 'Default Summarization'.

     

    What you need to do is go to the Modelling tab, select the column in question, then change the 'Default Summarisation' to 'Sum'. Now go back to the report design and re-create the table from scratch. The 'Sum of' will no longer appear.

     

    Regards,

    Dan

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Hmm, any chance you can upload a screen shot, I am not seeing that behavior in the default Table visualation with either Measures or Columns so apparently I am not simulating this correctly in my environment.

Narendra's avatar
Narendra
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi,

PFB Screen shot.

  • djnww's avatar
    djnww
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    Hi Narenda,

     

    The 'Sum of' will occur when you apply an aggregation which is different to the field/column's 'Default Summarization'.

     

    What you need to do is go to the Modelling tab, select the column in question, then change the 'Default Summarisation' to 'Sum'. Now go back to the report design and re-create the table from scratch. The 'Sum of' will no longer appear.

     

    Regards,

    Dan

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      This worked for me...

      File | Options and Settings | Options | Current File | Report settings | Default summarizations | UNCHECK "For aggregated fields, always show the default summarization type"

      • kiriyandrey's avatar
        kiriyandrey
        New Member
        3 years ago

        It's a solution!!!

        Thank You.

    • Narendra's avatar
      Narendra
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      Hi djnww,

      Thanks you so much. Now my issue is resloved.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    OK, for the life of me, I can't reproduce this, can you send a screen shot of the visual configuration box, the graph icon, not the paintbrush, I just need to see what is listed where in terms of Rows, Columns and Values. Hopefully we can get to the bottom of this.

    • Narendra's avatar
      Narendra
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      Hi,

      PFB screen shot

       

       

      • Sean's avatar
        Sean
        Icon for Community Champion rankCommunity Champion
        10 years ago

        Narendra If I understand what you are trying to do is sum those columns but not say Sum of in the name?

         

        go to the Modeling tab and create a New Measure with whatever name you choose

         

        Total Asset Count = SUM(TableName[Asset Count]) 

         

        and then use this Measure in your table

         

        let me know if this is what you are trying to do?