Forum Discussion
Very Slow Measure
I'm needing to write a measure that brings back the total value of customers who didn't drop a specific service. I have a measure that does this but it's so slow that it won't be accepted by end user...
I'm now wondering if there's a more simple approach.
I have a measure that calculates economic benefit. If I'm able to just filter out those flagged as "stopped" that should give me what I need.
This is more or less what I'm after but the filter doesn't get recognized. This is just an update for the "Total Charges" measure already in the file. Am I missing anything where the filter is ignored?
Actual Total Charges =
CALCULATE(
SUMX(Charges, [$ First Upgrade Internet Benefit]),
FILTER(Charges,
[Stopped Customers] <> 1)
)