Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JulioCastillo
Helper I
Helper I

Filter function - with two conditions on the same table

Hello
I'm trying without success to create a filter. The first filter is working fine if he stands alone.
As soon as I try to add the second condition I get an error message.
Thanks in advance for your input.
Delivery Costs =
Calculate(SUM('Anticimex AG$G_L Entry (2)'[Amount]),FILTER(Pnl,Pnl[Category II] = "COSTS"),
FILTER('Anticimex AG$G_L Entry (2)',[Global Dimension Code 1] = "DE"))
1 ACCEPTED SOLUTION
JulioCastillo
Helper I
Helper I

Hi,

It was a user mistake the formula is working now.

Thanks a lot for your feedback.

@PaulDBrown 

View solution in original post

2 REPLIES 2
JulioCastillo
Helper I
Helper I

Hi,

It was a user mistake the formula is working now.

Thanks a lot for your feedback.

@PaulDBrown 

PaulDBrown
Community Champion
Community Champion

What error are you getting?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.