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

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

Hi,

My column names doesn't have any prefix as  Sum of but when i add this columns in a table grid  then it is showing a Sum of Column Name.

 

 

  • 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