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, 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.

 

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

5 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi PhoenixBird66 

    Excluding Outliers =
    VAR x=  [January % Increase]
    RETURN
    CALCULATE(
    [January % Increase]
    FILTER(
    yourTable,
    [January % Increase] >= -1 && [January % Increase] <= 1
    ),
    ISBLANK(yourTable[StdSvcKey]) = FALSE
    )