79156175

Date: 2024-11-04 16:05:47
Score: 1.5
Natty:
Report link

I am not sure SUM is just syntactic sugar for simple sums of a colum, or that SUM ( 'Table'[Column] ) is shorthand for (and will be translated to by the engine at query time) SUMX ( 'Table' , 'Table'[Column] ).

In my experience is a performance difference:

see https://maxpowerbi.pro/the-dax-summary-pattern/

It's also what Marco Russo and Alberto Ferrari recommend https://www.daxpatterns.com/currency-conversion/

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: Derek Meyer