Calculated Column to Measure

RyanHare92 — Thu, 27 Apr 2023 15:19:47 GMT

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.

Re: Calculated Column to Measure

lbendlin — Mon, 01 May 2023 01:20:35 GMT

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

topic Re: Calculated Column to Measure in Custom Visuals Development Discussion

Calculated Column to Measure

Re: Calculated Column to Measure