Add a count measure to a metric set

Contents[Hide]

1. Overview

This article shows you how to add a Count measure to a metric set from the Metric Set / Data Binding Panel.

2. Adding a count measure

2.1. Create a new metric set

For this example, create a new metric set from the main menu.

Find your data connector in the Explore window and expand its [Production].[Product] table.

Drag the Name column from the Explore window to the canvas.

Drag Name column to the canvas
Drag Name column to the canvas

This opens the Metric Set panel beside a table visualization showing the values from the Name column.

Metric Set Designer
Metric Set Designer

2.2. Add a count measure

Click click to add in the MEASURES field of the Metric Set panel.

Click to add a measure
Click to add a measure

The Metric Set panel is replaced with a list of available measures you can add. Scroll down to the Calculated Elements section and click <Count>.

Select the Count measure
Select the Count measure

A Count measure is added to the MEASURES field of the Metric Set panel, and the table visualization is updated to show a Count Measure column.

Next, click the Edit icon for the Count measure.

Edit the Count measure
Edit the Count measure

In the Configure Metric Set Element dialog, go to the Format field and check if its value is N0. If not, change it and then click Submit.

Check the format string for the Count measure
Check the format string for the Count measure

3. Notes

  • Automatic count measures are not supported for OLAP. So this article does not apply if you're connecting to OLAP data.

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri