5 Replies Latest reply: Jan 6, 2016 4:19 AM by Sangram Reddy RSS

    Exclusion

    Cesar Polo

      Hi,

       

      How can I make a measure conditioned to a selected option in a filter pane?

       

      For instance, my filter option under Department (this is the name of the field) is "CORP", I want the measure to adjust to this filter wheter CORP is selected or not.

       

      It could be something like: if(Department = 'CORP', SUM(Amount1), SUM(Amount2))

       

      I would appreciate your help.