Filter out errors in CalculateTable

[zebing]

Hi,  I have created a new table named "LCM_100K" based on another table named "OH_Totals" . I am bringing OH_Totals in via Power Query which removes any rows with errors. However, when I create a new table "LCM_100K" based on OH_Totals, errors are getting in the way. Do I need to write my formula in such a way to remove that error? How would I do that or how would I fix? Thanks.

[ryan_mayu · Accepted solution]

why not just use filler

=filter('OH_total', type="LCM" && impact>100000)

[zebing]

Did you mean to do it like this within CALCULATETABLE? Or should that happen somewhere else? Tried it within CALCULATETABLE but the result seems to be the same.

[zebing]

Sorry, I was wrong, that did in fact fix it. Thanks!

[ryan_mayu]

you are welcome