Forum Discussion

ratercero's avatar
ratercero
Helper III
9 years ago
Solved

Conditional duplicate secuence count 2 columns

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:          ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    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's avatar
    Phil_Seamark
    9 years ago

    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]
            )
           ))
ratercero's avatar
ratercero
Helper III
9 years ago

Hello Phil_Seamark,

 

Im getting this error:

 

 

 

 and the variable does exist:

 

 

 

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi ratercero,

 

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

  • ratercero's avatar
    ratercero
    Helper III
    9 years ago
    I tried both and non of them work, you think it has something to do with the march update?
    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      9 years ago

      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's avatar
        ratercero
        Helper III
        9 years ago

        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.