You can download the pbix file for your self practice sessions from : drive.google.com/file/d/1_KtXpDtJiWcQl4tSLuitSwu8t0UB7ael/view?usp=sharing Do not forget to Like ,Subscribe and comment which keeps me motivated !
Thank you for your comment Chandan. I am not too clear with your question .You can explain it a bit more so that we can try to throw some light .In short "Both of these functions are used to create summarised tables. The difference between the two is that the SUMMARIZE function allows us to have a row and a filter context within the expression whereas the SUMMARIZECOLUMNS function only allows us to have a filter context and no row context."
SummarizeColumns worked in my data model perfectly. Then I imported my measure into my report and using the same exact visual, I got the error from your video. It's curious that it worked in one report but not another.
Hi... Can you help me to solve this question ?? Which of the following DAX function will return a table :- 1 SUMMARIZECOLUMNS 2 CALCULATETABL 3 RELATEDTABLE 4 All of the above 5 None of the above Please answer the question??
You can download the pbix file for your self practice sessions from :
drive.google.com/file/d/1_KtXpDtJiWcQl4tSLuitSwu8t0UB7ael/view?usp=sharing
Do not forget to Like ,Subscribe and comment which keeps me motivated !
Spot on video. Surprisingly, there aren't that many vids on SummarizeColumns and none show use of the filter. Thank you
Thnx Ross
This is a really good comparison
Thank you :)
We can use filter in summarizecolumn as well. Difference is between table load. Summarizecoloumn is more optimised
Thank you for your comment Chandan. I am not too clear with your question .You can explain it a bit more so that we can try to throw some light .In short "Both of these functions are used to create summarised tables. The difference between the two is that the SUMMARIZE function allows us to have a row and a filter context within the expression whereas the SUMMARIZECOLUMNS function only allows us to have a filter context and no row context."
@@powerbizone Tnks for explaining
You're welcome dear !If you like it don't forget to Subscribe !
Good explanation, thank you!
Glad it was helpful!
nice tutorial, thank you
You are welcome!
SummarizeColumns worked in my data model perfectly. Then I imported my measure into my report and using the same exact visual, I got the error from your video. It's curious that it worked in one report but not another.
:)
Hi...
Can you help me to solve this question ??
Which of the following DAX function will return a table :-
1 SUMMARIZECOLUMNS
2 CALCULATETABL
3 RELATEDTABLE
4 All of the above
5 None of the above
Please answer the question??
Should be 4. All of the above
finished watching
Great
😍
:)
not clear too much confusing
could you please elaborate which part was confusing :)