Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors