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

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