Calculated Column to Measure

[RyanHare92]

Hi,

I currently have a calculated Table that has the following calculated column:

Packets Received =

CALCULATE(

    COUNTROWS('Datalake info'),

    FILTER(

        'Datalake info',

        'Datalake info'[Date_Arrived] <> BLANK()

        && 'Datalake info'[Date_Arrived] <= Progression[Date]

        && RELATED('Script Type'[SFA]) = "N"

        && RELATED('Script Type'[Script Type]) <> "Secure Exchange"

    )

)

The above works fine, but I've only just realised the issue in having this as a calculated column is causing. No slicers are affecting the results as these are not dynamic.

I've been trying to find an alternative using a measure to allow this to be affected by my slicers, but I can't seem to figure out how. It seems like it does like this part:

&& 'Datalake info'[Date_Arrived] <= Progression[Date]

I'm assuming that it doesn't know what I'm referencing to as it's not part of a table anymore. 

For more info, I'm using this in a line chart to have a count of received material up to each date.

Any help is appreciated.

[lbendlin]

measures need aggregations.  Instead of Progression[Date] you need to use things like SELECTEDVALUE(Progression[Date]) or MAX(Progression[Date])  etc.