topic Re: Help with Powerbi Formula in Custom Visuals Development Discussion

Help with Powerbi Formula

ahmer_malick — Fri, 11 Jul 2025 16:39:48 GMT

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 — Fri, 11 Jul 2025 19:17:43 GMT

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 — Fri, 11 Jul 2025 20:36:37 GMT

I tried this one previously but didnt work