Forum Discussion
Looking up invalid data on a dense spool
- 4 years ago
Hi powerbi-dev pkeefer Anonymous ,
This issue has been submitted internally(ICM: 305645248). Please be patient to wait for fixing. If there is any news, I will update it here.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
We started receiving this error yesterday as well. It sounds like a similar scenario to yours: CALCULATE with a relatively simple filter; only deleting the offending measures made the error go away.
Not all measures were causing problems, only a small number of them that had more than one logical operator, e.g.
age_1 =
var maxDate = MAXX(ALLSELECTED(Payables), Payables[document_date])
return CALCULATE
(
SUM(Payables[balance_amount_dc]),
FILTER
(
Payables,
var docAge = DATEDIFF(Payables[document_date], maxDate, DAY)
return Payables[document_amount_dc] <> 0 && docAge >= 31 && docAge <= 60
)
)
Other, very similar measures, are working fine, e.g.
age_0 =
var maxDate = MAXX(ALLSELECTED(Payables), Payables[document_date])
return CALCULATE
(
SUM(Payables[balance_amount_dc]),
FILTER
(
Payables,
var docAge = DATEDIFF(Payables[document_date], maxDate, DAY)
return Payables[document_amount_dc] <> 0 && docAge <= 30
)
)
Since this is an aging report, I was able to work around it by simplifying filter conditions in the later buckets and just subtracting the earlier buckets.
There are only two tables - both imported from SQL. The table with the measures causing issues has around a million rows.