4 Replies Latest reply on Aug 7, 2018 11:45 AM by John Farzing

    Conditional Filtering with Parameter

    John Farzing

      Hello,

       

      I have created a conditional filter that is based on a string being entered into a parameter. I am using this calculation in the filter for State:

       

      {FIXED [State]: MAX([Order ID] = [Parameters].[Order ID])}

       

      This works as intended when the string is entered into the parameter. However, I would like for the filter to be unfiltered when nothing has been entered into the parameter and am having trouble accomplishing this. It is showing no states when I would like all states to be shown. I have attached a sample workbook. Many thanks for any help!

       

      I am using this on a dashboard where the parameter performs other functions as well so I need this to work with the parameter.