Definition

DISTINCTCOUNT counts the number of unique, non-blank values in a column.

Formula

Unique States = DISTINCTCOUNT('Table'[State])

Use

When you need to count the distinct (unique) values in a column, excluding blanks.

Flowchart

Steps

1. Go to report view

2. Insert a card 

3. drag the newly created measure "DistinctCount" from the date pane into card 

4. You will get the DistinctCount displayed in the card