-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Implicit or Explicit?
- Thread starter cnestg8r
- Start date
According to the experts:
"Never use shortened CALCULATE syntax."
https://www.sqlbi.com/articles/rules-for-dax-code-formatting/
So I would say your first option is preferred.
"Never use shortened CALCULATE syntax."
https://www.sqlbi.com/articles/rules-for-dax-code-formatting/
So I would say your first option is preferred.
Upvote
0
cnestg8r
Active Member
- Joined
- Dec 26, 2005
- Messages
- 287
- Office Version
- 365
- Platform
- Windows
- Mobile
Ozeroth,
Thank you for your response. BTW, for 3.5 years I commuted to Melbourne from Atlanta every month.
As I read the "Italian" preference, I think they would go the other way which surprised me. I have run timings and only see differences within the repeated measurement error. Maybe Matt will weigh in.
Thank you for your response. BTW, for 3.5 years I commuted to Melbourne from Atlanta every month.
As I read the "Italian" preference, I think they would go the other way which surprised me. I have run timings and only see differences within the repeated measurement error. Maybe Matt will weigh in.
Upvote
0
No problem.
I think the reason for their preference is readability rather than performance (which I assume is identical).
With a function like CALCULATE which interacts with filter context (and row context if present) in a special way, it is best for the code to explicitly show that it is being called.
But opinions may differ on this one
I think the reason for their preference is readability rather than performance (which I assume is identical).
With a function like CALCULATE which interacts with filter context (and row context if present) in a special way, it is best for the code to explicitly show that it is being called.
But opinions may differ on this one
Upvote
0
