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

    Distinct Count of records based on Dimension

    faris meghani



      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