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.