Reply
RyanHare92
Helper I
Helper I

Calculated Column to Measure

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.



1 REPLY 1
lbendlin
Super User
Super User

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

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)