Forum Discussion
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] )
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/
2 Replies
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/