I’m trying to help optimize a PBIX for someone pretty new with DAX. I dug into the code and they’ve got the following GROUPBY measure (this is also the main culprit for performance for somewhat obvious reasons). What I don’t get is how/why its working without CURRENTROW(). It does provide the correct values, just very slowly. Can you shine any light on what’s happening with this? The only way I can think of to replicate it is a summarize within the sumx, but that is going to also be a performance killer.
Measure = sumx( GROUPBY( 'Sales', 'Sales'[Record Num] ), if( [OtherMeasure] < ([OtherMeasure2]), divide( (OtherMeasure3]*[OtherMeasure4]), [OtherMeasure2] ), 0 ) )