Dax to find out which values are outside +/10% toleance

[forgetmenot]

I have already added a measure for  % difference between current month and previous month and have a % difference column in matrix, I want to now identfy which of those are outside tolerance of +/-10% . 

Can someone please help me?

I have tried the following: 

Margin type =

Switch (

    TRUE(),

    [MONTH_%_DIFF]<=-10 || [MONTH_%_DIFF]>=10,"Outside of Tolerance,""Within Tolerance")

and 

above tolerance = IF([MONTH_%_DIFF]>[T1_HIGH],

IF([MONTH_%_DIFF]<[T2_LO],

"Yes","No"))

-- I set T1 High as 10 and T2 Low as -10

[Dangar332]

hi, @forgetmenot 

change logic to

above tolerance = IF([MONTH_%_DIFF]>[T1_HIGH] ||

[MONTH_%_DIFF]<[T2_LO],

"Yes","No")

Did i answer your question? Mark my post as a solution which help other people to find  fast and easily.

[forgetmenot]

Thank you for replying. I have tried using your modified expression and am getting mixture of yes and No so am definitely a step closer, but some of the "no" are still outside the tolerance. its still not working as it should. Can you please advise?

[Dangar332 · Accepted solution]

hi, @forgetmenot 

change logic to

above tolerance = IF([MONTH_%_DIFF]>[T1_HIGH] ||

[MONTH_%_DIFF]<[T2_LO],

"Yes","No")

set [T1_HIGH]= 0.1  and    [T2_LO]=-0.1

because if we compare percentage we can not use % sign insted of it we must use 10% = 0.1  and -10% = -0.1

i hope now you get your answer

[forgetmenot]

Thank you so much! Schoolgirl error! 😮
Funny how sometimes we overlook the most obvious of things. Much apprecaited thanks a bunch !!!  🙂