Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculated Column to Measure
04-27-2023
08:19 AM
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:
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.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2023
06:20 PM
measures need aggregations. Instead of Progression[Date] you need to use things like SELECTEDVALUE(Progression[Date]) or MAX(Progression[Date]) etc.

Helpful resources
Top Kudoed Authors (Last Month)
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |