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[...
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/
with || worked like a charm.
Completely forgot about "and" function... Rookie mistake