Total of rows until date

[IAM]

Hello,

I have a list with cable numbers and the day they got installed. I want to see the running total of the number of cable's that are installed.

I made a DateDimension, and connected a relation from the datadimension to my progresstool.

I've tried different measures, but they are not giving me the desired visual, does anyone know what to do?

Here is a link to the file:

PowerBIhelp.zip 

[v-yadongf-msft]

Hi @IAM ,

I am so glad to hear that your problem has been solved . Please consider Accept it as the solution to help the other members find it more quickly.

Best regards,

Yadong Fang

[IAM · Accepted solution]

I have it working with measure:

Measure =

CALCULATE (

    COUNT ( ProgressTool[Cable number] ),

    FILTER (

        ALLSELECTED ( ProgressTool ),

        ProgressTool[Installed - Relation] <= MAX ( DateDimension[DateKey] )

    )

)