+ Reply to Thread
Results 1 to 2 of 2

Using distinct count measure in Pivot table

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Using distinct count measure in Pivot table

    Hi all,

    i am trying to create a measure in a pivot table that gives me a distinct count for a text field.

    Here the example. Basically i need to create the measure "family count":


    Thank you!

  2. #2
    Forum Guru
    Join Date
    MS-Off Ver
    Excel 2019

    Re: Using distinct count measure in Pivot table

    Hello HR85 and Welcome to Excel Forum.
    I am assuming that you are using a version of Excel (not windows) that supports Power Pivot.
    Attached is a file that illustrates one way to accomplish what I believe you want.
    1. Convert the data into an Excel table (Ctrl + t)
    2. Add the table to the data model
    3. Add the following measure: Family Count:=DISTINCTCOUNT(Table1[Family])
    4. Produce a pivot table from the data model with category in the Rows area and the Family Count measure in the Values area
    For future reference you may get faster results if you utilize the information in the banner at the top of the page to upload a sample Excel file to your post.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Pivot Table Distinct Count
    By matth3881 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-25-2021, 08:50 AM
  2. Replies: 1
    Last Post: 08-31-2020, 11:54 PM
  3. Pivot Table: Grand Total different measure from Column measure
    By chinneywow in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-07-2019, 06:22 AM
  4. [SOLVED] Count distinct value and SUM in the same Pivot table
    By Faridwahidi in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-15-2019, 11:35 AM
  5. Replies: 1
    Last Post: 11-29-2011, 10:52 PM
  6. How do I set up Distinct Count in a Pivot Table?
    By STOFF in forum Excel General
    Replies: 1
    Last Post: 04-18-2006, 01:25 PM
  7. [SOLVED] count distinct in Pivot table
    By soe in forum Excel General
    Replies: 1
    Last Post: 02-22-2005, 10:06 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1