Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
zebing
New Member

Filter out errors in CalculateTable

‎06-12-2024 02:50 PM

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.CalculateTable.png

Labels:
Message 1 of 5
512 Views
0
1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

‎06-12-2024 06:20 PM

why not just use filler

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Message 2 of 5
475 Views
0
4 REPLIES 4
ryan_mayu
Super User
Super User

‎06-12-2024 06:20 PM

why not just use filler

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Message 2 of 5
476 Views
0
zebing
New Member
In response to ryan_mayu

‎06-13-2024 11:22 AM

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.

 

Screenshot 2024-06-13 131939.png

Message 3 of 5
457 Views
0
zebing
New Member
In response to zebing

‎06-13-2024 11:33 AM

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

Message 4 of 5
455 Views
0
ryan_mayu
Super User
Super User
In response to zebing

‎06-13-2024 05:56 PM

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Message 5 of 5
435 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All