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

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