Conditional duplicate secuence count 2 columns

[ratercero]

Hello,

I need to count de sequence a batch number and a description repeats except if description = "OK", here es my current table:

Here is what I'm looking for:

Thank you

[Phil_Seamark · Accepted solution]

Hi @ratercero,

I have the March Update and have built a very simple version which I have uploaded here.  Please download and see if it works for you.

PBIX file to test

[Phil_Seamark]

Hi @ratercero

How close is this to your requirements?

Sequence Count = COUNTROWS(
            FILTER(
                'Table',
                'Table'[BATCH_NUMBER_1]=EARLIER('Table'[BATCH_NUMBER_1]) 
                && 'Table'[DESCRIPTION]="ok" 
                && EARLIER('Table'[DESCRIPTION]) <> "ok"
            )
           )

[ratercero]

Hello @Phil_Seamark,

Im getting this error:

 and the variable does exist:

[Phil_Seamark]

Hi @ratercero,

Are you creating these as calculated columns?  Rather than as measures?

[ratercero]

I tried both and non of them work, you think it has something to do with the march update?

[Phil_Seamark · Accepted solution]

Hi @ratercero,

I have the March Update and have built a very simple version which I have uploaded here.  Please download and see if it works for you.

PBIX file to test

[ratercero]

@Phil_Seamark,

This is very close to whagt im looking for, but notice on batch "005326" Description "RP" , is twice, so it should count as 2 the second time it shows.

[Phil_Seamark · Accepted solution]

Hi @ratercero,

Please try this slightly modified column.

Sequence Count = COUNTROWS(
            FILTER(
                'Table',
                'Table'[BATCH_NUMBER_1]=EARLIER('Table'[BATCH_NUMBER_1]) 
                && 'Table'[DESCRIPTION]<>"ok" 
                && 'Table'[DESCRIPTION] = EARLIER('Table'[DESCRIPTION])
                && 'Table'[c_FinishedDT] <= EARLIER('Table'[c_FinishedDT]
            )
           ))