Forum Discussion
Help with Powerbi Formula
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
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])
)
)
)
I tried this one previously but didnt work
2 Replies
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])
)
)
)
I tried this one previously but didnt work