Great video. If I had to write it, I would probably begin with over-complicating it with Summarize() and SumX() formulas. The last DAX formula was very concise an simple. Great work as always!
Awesome explanation, clean and clear. Thanks for making this clear. I used to write dax keeping just the expected result in mind. Going forward will try to write optimized code.
@@SQLBI , Obviously, it is the same. That said, it turns out the crux of the DAX optimization is avoiding the non-additivity of DISTINCTCOUNT by storing the individual daily delta results in a virtual column. This is a clever solution, however, it is exactly this kind of issues that makes me NOT enjoy DAX, due to the level of details one must familiar himself\herself with the nuts and bolts of the language, in order to create efficient solutions, instead of focusing his creativity on one’s project. One may hope that in the age of AI, a clever program would find ways to take care of such issues for the user automatically. I wonder, if you gave the original solution to DAX Optimizer, would it generate the suggested solution? Other than that, a very good presentation of the problem and its solution. Thanks very much.
@@КириллЧесноков-л7д what you wrote doesn't make any sense. Do you mean "Cumulative" instead of "Additive"? I think you don't know how DAX work if you mean that.
this man is like Messi of DAX, hat off to you sir !
Thank Alberto, your videos are always entertaining and insightful to watch!
Great video. If I had to write it, I would probably begin with over-complicating it with Summarize() and SumX() formulas. The last DAX formula was very concise an simple. Great work as always!
Awesome explanation, clean and clear. Thanks for making this clear. I used to write dax keeping just the expected result in mind. Going forward will try to write optimized code.
Excellent video and the final dax measure is a great inspiration.
Alberto!
We missed you!
Thanks for the as always wonderful and very informative video!
Amazing video again. I really need to look at using visual calculations in my reports - it would really help with the speed.
As always, an excellent and informative video. Thank you Alberto!
Thanks a lot for your share, enjoy your video.Your solutions for the question can lead to good cocepts and approaches to learning DAX, thanks again.
Excellent technique !!! Thank you so much for sharing
Alberto is always on point!
I love this kind of videos, Grazie mille Alberto.
Amazing Teachings sir !! Massive respect
Having urge to attend that Optimizing Dax course but it's too expensive for me
Always look forward to your videos
great work ! thanks
Could you create a calculated table with unique orders so that you no longer have to deal with DistinctCount?
Great video BTW
Yes - but it wouldn't work if you filter by product. It's a good optimization when you have a large amount of data,
Awesome!
I still prefer treatas() for such database as both start and end date can have same syntax;)
Great!
❤
Maby I'm wrong but I think [Received RT] - [Delivered RT] (measures) is not the same as
VAR Deltas =
ADDCOLUMNS (
ALL ( 'Date'[Date] ),
"@Delta", [Orders Received] - [Orders Delivered]
)
VAR MaxDate = MAX ( 'Date'[Date] )
VAR Result =
SUMX (
FILTER ( Deltas, 'Date'[Date]
Why it's not the same? It's an additive measure.
@SQLBI but [received rt] and [delivered rt] are non additive
@@SQLBI , Obviously, it is the same. That said, it turns out the crux of the DAX optimization is avoiding the non-additivity of DISTINCTCOUNT by storing the individual daily delta results in a virtual column. This is a clever solution, however, it is exactly this kind of issues that makes me NOT enjoy DAX, due to the level of details one must familiar himself\herself with the nuts and bolts of the language, in order to create efficient solutions, instead of focusing his creativity on one’s project. One may hope that in the age of AI, a clever program would find ways to take care of such issues for the user automatically. I wonder, if you gave the original solution to DAX Optimizer, would it generate the suggested solution? Other than that, a very good presentation of the problem and its solution. Thanks very much.
@@КириллЧесноков-л7д what you wrote doesn't make any sense. Do you mean "Cumulative" instead of "Additive"? I think you don't know how DAX work if you mean that.