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]
            )
           ))
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

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'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?