Forum Discussion
DAX Engine Changes in Power BI Desktop October 2024 Update?
- 1 year ago
I'm not sure but I've reached out to Jay on socials to see if he knows.
Don't know his handle on here.
I'm not sure but I've reached out to Jay on socials to see if he knows.
Don't know his handle on here.
- Martin_D1 year agoSolution Sage
Hi KNP ,
Thank you for your support. I just tried to reproduce this behaviour on a machine with the old Power BI Dektop version. Maybe I did a change in my code the caused my obersvation, not the update that I did at about the same time.
This code still translates into a query using callbacks:DEFINE ---- MODEL MEASURES BEGIN ---- MEASURE FactOnlineSales[Large Sales LC] = SUMX ( 'FactOnlineSales', IF ('FactOnlineSales'[SalesAmount] >= 50, 'FactOnlineSales'[SalesAmount] ) ) ---- MODEL MEASURES END ---- EVALUATE SUMMARIZECOLUMNS ( 'DimDate'[CalendarYear], "Large Sales LC", [Large Sales LC] )Whereas this code does not translate into a query using callbacks:
DEFINE ---- MODEL MEASURES BEGIN ---- MEASURE FactOnlineSales[Sales LC] = SUM ( 'FactOnlineSales'[SalesAmount] ) MEASURE FactOnlineSales[Large Sales LC] = SUMX ( 'FactOnlineSales', VAR _Sales = [Sales LC] RETURN IF ( _Sales >= 50, _Sales ) ) ---- MODEL MEASURES END ---- EVALUATE SUMMARIZECOLUMNS ( 'DimDate'[CalendarYear], "Large Sales LC", [Large Sales LC] )Interesting: The callback solution runs 167 ms, the non-callback solution ran 24894 ms. Optimized code ran 40ms. So you can mess up even further by getting rid of the callback solution 😀
Kind regards,
Martin