Cumulative Count DAX

Try this measure

 

CumulativeCompleteCount = 
CALCULATE(
    COUNTROWS(TableName), 
    FILTER(
        ALLSELECTED(TableName[Build Complete FC Date]), 
        TableName[Build Complete FC Date] <= MAX(TableName[Build Complete FC Date]) &&
        TableName[Build Complete FC Status] = "Complete"
    )
)

Thanks for the reply from aduguid , please allow me to provide some information to add:
Hi  NessFlood ,

According to the error message, you are using the table + column name 'CBR_REPORT' [BLD110 Build Complete FC] in allselect(), followed by 'CBR_REPORT' [Build Complete FC Status] which is not referenced in the dax equation

You can try the following DAX:

Measure：

CumulativeCompleteCount_Measure =
IF(
    MAX([Build Complete FC Status])="Complete",
COUNTX(
    FILTER(ALL('CBR_REPORT'),
    'CBR_REPORT'[Build Complete FC Status]="Complete"&&'CBR_REPORT'[BLD110 Build Complete FC]<=MAX('CBR_REPORT'[BLD110 Build Complete FC])),[Ref ID]))

Caliculated Column：

CumulativeCompleteCount_Column =
IF(
    [Build Complete FC Status]="Complete",
COUNTX(
    FILTER('CBR_REPORT',
    'CBR_REPORT'[Build Complete FC Status]="Complete"&&'CBR_REPORT'[BLD110 Build Complete FC]<=EARLIER('CBR_REPORT'[BLD110 Build Complete FC])),[Ref ID]))

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi  NessFlood ,

 

Are you referring to Meausure in the Total row not 13?You can use IF+ ISINSCOPE() to determine if it is the total row, customize the rule .

Here are the steps you can follow：

1. Create measure.

correct count =
IF(
    ISINSCOPE('CBR_REPORT'[Ref ID]),[CumulativeCompleteCount_Measure],COUNTX(FILTER(ALLSELECTED('CBR_REPORT'),[CumulativeCompleteCount_Measure]<>BLANK()),[Ref ID]))

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly