7 Replies Latest reply on Aug 11, 2016 7:45 AM by Tom W

    Distinct Count of records based on Dimension

    faris meghani

      Hello,

       

      i'm trying to determine how to count the distinct number of records in a tableau based on a specific key when the dimension value equals something specific.

       

      Dimension: Opportunity Status Name

      Dimension Values: Applied, Accepted, Enrolled, Started

       

      Measure Keys: Inquiry Key, Opportunity Key

       

      The table is structured where the Inquiry Key is unique in the table, but the Opportunity Key has a 1 to many relationship in the table. So essentially, 1 Opportunity Key can have several Inquiry Keys. And I'm trying to get a unique count of Opportunity Key where the Dimension Values equal what I listed above.

       

      Any help would be greatly appreciated.

       

      Thank You