Forum Discussion

PhoenixBird66's avatar
PhoenixBird66
Icon for Helper III rankHelper III
7 years ago
Solved

DAX measure with multiple FILTERs

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...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago
    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
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago
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's avatar
PhoenixBird66
Icon for Helper III rankHelper III
7 years ago

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