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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

VAR filter

Hey, got a little problem. After applying second filter the formula is crashing. Could someone take a look on it?
 
Measure 2 =
VAR TU =
    FILTER (
        FILTER(
            TJob, TJob[SekundærNavn] = "Quality control HMD"),
            TJob[SekundærNavn] = "Touch up")
RETURN
    AVERAGEX( TU, TJob[Time diff] )
1 ACCEPTED SOLUTION
ValtteriN
Super User
Super User

Hi,

I recommend reading this article by SQLBI:Specifying multiple filter conditions in CALCULATE - SQLBI

Basically you can use OR and AND symbols to add multiple filter conditions.


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/





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

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Anonymous
Not applicable

with || worked like a charm.

 

Completely forgot about "and" function... Rookie mistake

ValtteriN
Super User
Super User

Hi,

I recommend reading this article by SQLBI:Specifying multiple filter conditions in CALCULATE - SQLBI

Basically you can use OR and AND symbols to add multiple filter conditions.


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/





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

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.