# How do I add a count(\*) measure to a view?

**URL:** <https://community.omni.co/t/how-do-i-add-a-count-measure-to-a-view/65>\
**Category:** Modeling\
**Created:** [May 15, 2024, 8:46pm UTC](https://community.omni.co/t/how-do-i-add-a-count-measure-to-a-view/65 "2024-05-15T20:46:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![conner](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/conner/32/11_2.png) [@conner](https://community.omni.co/u/conner)\
**Post date:** [May 15, 2024, 8:46pm UTC](https://community.omni.co/t/how-do-i-add-a-count-measure-to-a-view/65/1 "2024-05-15T20:46:54Z")

</div>

**For every view in Omni, we automatically generate a `COUNT(*)` measure for you.** You’ll find this measure in your field picker, with the name `[View Name] Count`, e.g. `Users Count`.

 ![users_count](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/f713d8bd09861247029cae031b5c7c72fa9af4e9.png)

Since `COUNT(*)` doesn’t depend on a particular field (i.e. it’s counting _any_ row in your table, regardless of column value), you’ll only ever need one measure with this definition. If you’d like to have a count(\*) measure with a filter ([creating a filtered measure](https://community.omni.co/t/how-can-i-add-a-filter-on-just-one-column-measure-filtered-measure/31)), you can duplicate the field and then add a filter to the copy:

 ![duplicate_field](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/39936b4f17f564b60d1aa81ec0d34d84a706b1fc.png)

If you’re ever unsure if your `Count` measure is a `COUNT(*)` or a `COUNT(DISTINCT)`, you can pop open the SQL tab to check:

 ![order_id_count](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/6848034c5910b837cb32ffe5509cbe1e73f90c31.png)