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: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

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
611 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
574 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
575 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
556 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
554 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
534 Views
0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

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

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All