4 Replies Latest reply on Feb 9, 2017 2:59 PM by Alec Chen

    Filtering nulls based on multiple measures

    Alec Chen

      Hi, I would like to filter out null values based on 2 measures:

       

      For example:

       

      I want to filter out when ORIGINAL_ALLOCATION_QUANTITY is null and NUM_CARD_ISSUE is 0. However, when I use the automatic hide nulls function, it removes any NULL for ORIGINAL_ALLOCATION_QUANTITY, regardless of if NUM_CARD_ISSUE has any value or not. I'm assuming I would need to create a parameter, but not sure how to begin.

       

       

      Thanks in advance.