DAX measure with multiple FILTERs

[PhoenixBird66]

I want to create a measure called "Excluding Outliers" - it needs to return the value of [January % Increase], but if that value is greater than 100% or less than -100% it should return a blank. Also, if the StdSvcKey field is blank, it should return a blank value.

Any ideas of the best way of doig this? Any help would be greatly appreciated as I'm a bit stuck.

[Mariusz]

Hi @PhoenixBird66 

Excluding Outliers =

VAR x=  [January % Increase]

RETURN

CALCULATE(

[January % Increase]

FILTER(

yourTable,

[January % Increase] >= -1 && [January % Increase] <= 1

),

ISBLANK(yourTable[StdSvcKey]) = FALSE

)

[PhoenixBird66]

Thanks for replying. Doesnt seem to like the FILTER...

[Mariusz]

Hi @PhoenixBird66,

Sorry, I missed the "," before the filter 

Mariusz

[Mariusz · Accepted solution]

Hi @PhoenixBird66 

This is how corrected measure shoud look like

Excluding Outliers =

VAR x = [January % Increase]

RETURN

CALCULATE(

[January % Increase],

FILTER(

Sales,

x >= -1 && x <= 1

),

ISBLANK(Sales[StdSvcKey]) = FALSE

)

Thanks 
Mariusz

[PhoenixBird66]

Yes this works - thanks so much for your help! I'm so happy! 🙂