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

    Conditional Filtering with Parameter

    John Farzing



      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.