Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Summarize VS Summarizecolumn function in DAX

Hi,   Actually i am confused with Summerize and Summerizecolumn functions. Can somebody explain it in easier words with example.   I have read sqlBi blog which is preety good, i am not able to u...
Need Help
Show and Tell
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Typically, it is recommended to use SummarizeColumns to add columns rather than Summarize.

     

    Best Regards,

    Giotto Zhi

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Before posting quetion here i already checked SQLBI blog.

 

So as i can see you got the same result with just syntax change in SUmmerizecolumn and Summerize with addcolumns.

 

I am still curious is there any major  differance other than performance?

 

Thanks,

Pravin

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

Typically, it is recommended to use SummarizeColumns to add columns rather than Summarize.

 

Best Regards,

Giotto Zhi

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-gizhi-msft 

     

    I know it is recommended i am asking reason behind it. is it only for performance or something else?

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    • v-gizhi-msft's avatar
      v-gizhi-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi,

       

      SummarizeColumns can use Ignore function but summarize ca not.

      Reference:

      https://dax.guide/ignore/ 

       

      Best Regards,

      Giotto Zhi

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks v-gizhi-msft 

         

        Yes i have checked Ignore function with Summarize it is throwing error. You can use it with SUmmarizeColumns only.

         

        So the conclusion is we can omit blank from measure output without doing any furtherstep in SUmmarizecolumn.

        and other is it has better performance than Summarize.

         

        Thanks,

        Pravin