Help with Powerbi Formula

[ahmer_malick]

I am unable to convert this formula in Powerbi

IF(AZ3<>"",COUNTIF($AZ$2:AZ3,AZ3),"")

If the same work center comes each time , its keep on add 1 as a count till the last one is counted

[Chanty4u · Accepted solution]

Try this 

WorkCenter Running Count =

IF (

    NOT ISBLANK('Table'[WorkCenter]),

    CALCULATE(

        COUNTROWS('Table'),

        FILTER(

            'Table',

            'Table'[WorkCenter] = EARLIER('Table'[WorkCenter]) &&

            'Table'[Index] <= EARLIER('Table'[Index])

)

    )

)

[Chanty4u · Accepted solution]

Try this 

WorkCenter Running Count =

IF (

    NOT ISBLANK('Table'[WorkCenter]),

    CALCULATE(

        COUNTROWS('Table'),

        FILTER(

            'Table',

            'Table'[WorkCenter] = EARLIER('Table'[WorkCenter]) &&

            'Table'[Index] <= EARLIER('Table'[Index])

)

    )

)

[ahmer_malick · Accepted solution]

I tried this one previously but didnt work