3 Replies Latest reply: Aug 16, 2018 1:46 PM by Felipe Andrade RSS

    If Get Current Selection = this, exclude this

    Dan Coen


      I need to create an expression in a dimension that when one vale is selected, it will exclude the field of another dimension. For example,


      Dimension 'TM Type' has two dimensions, TM and SAM


      if TM Type SAM is selected, then the dimension, Adjustment Type, needs to exclude and adjustment call 'TM Adjustment' from the sales table.


      T His is what I have below but any help would be appreciated.


      =if(GetCurrentSelections([TM Type],'SAM'), Not Match([Adjustment Type],'TM Adjustment'),[Order - Adjustment Type])


      PS: tried this in the measure but it hit performance pretty bad.