Selective sum based on row type

Hi roelf ,

try this 

Column = 
IF('Tabelle23'[Type] ="stack",
    SUMX(
        FILTER(
            'Tabelle23',
              'Tabelle23'[DateTime] <= EARLIER(Tabelle23[DateTime]) && 'Tabelle23'[Type] = "pick"
                        ),
                'Tabelle23'[PickWeight]
             )
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi roelf ,

I have created a simple sample, please refer to it to see if it helps you.

Create 2 columns first.

stack = IF('Table'[Type]="stack",0,1)

minflagdate = 
calculate(MIN('Table'[DateTime]),FILTER(ALLSELECTED('Table'),'Table'[DateTime]>=EARLIER('Table'[DateTime])&&'Table'[stack]=0))

Then create a measure.

Measure = var _1= CALCULATE(SUM('Table'[PickWeight]),FILTER(ALL('Table'),'Table'[minflagdate]=SELECTEDVALUE('Table'[minflagdate])&&'Table'[Type]="pick"))
return
IF(MAX('Table'[Type])="stack",_1,BLANK())

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.