Delta Values, within subgroup (skip in between subgroups)

[Anonymous]

Hi,

I have a calculation for delta-values for subgroups that is fine within each group - however whenever there is a new subgroup the calculation is not able to differentiate,

How would I manange the calculation to handle the in between subgroups as well?

Where the calculation sasys 9.936.002 I would like to have zero - since the next line is a new subgroup (column "MeterTagID"),

Data_P16 = 
var _nextvalue=
CALCULATE(SUM('DataLog_P16'[Data]),FILTER('DataLog_P16',[Indeks]=EARLIER('DataLog_P16'[Indeks.1])))
var _data=
_nextvalue-[Data]
return IF(_nextvalue=BLANK(),BLANK(),_data)

[amitchandak]

@Anonymous , Try like

Data_P16 = 
var _nextvalue=
CALCULATE(SUMX(FILTER('DataLog_P16',[Indeks]=EARLIER('DataLog_P16'[Indeks.1] && [MeterTagID]=EARLIER('DataLog_P16'[MeterTagID]), 'DataLog_P16'[Data])))
var _data=
_nextvalue-[Data]
return IF(_nextvalue=BLANK(),BLANK(),_data)

[AllisonKennedy · Accepted solution]

@Anonymous You need to add meter tag matching: 

Data_P16 = 
var _nextvalue=
CALCULATE(SUM('DataLog_P16'[Data]),FILTER('DataLog_P16', [MeterTagID] = EARLIER('DataLog_P16'[MeterTagID]) && [Indeks]=EARLIER('DataLog_P16'[Indeks.1])))
var _data=
_nextvalue-[Data]
return IF(_nextvalue=BLANK(),BLANK(),_data)