> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Apply a filter to a single measure

> Add a filter to just one measure in a given query.

export const categoryIcons = {
  'administration': 'lock',
  'api': 'terminal',
  'connections': 'database',
  'dashboards': 'table-columns',
  'embed': 'code',
  'errors': 'exclamation',
  'modeling': 'wrench',
  'patterns': 'plus',
  'schedules & alerts': 'envelope',
  'visualizations': 'chart-column',
  'workbooks': 'book'
};

export const GuideSidebar = ({category, relatedLinks, updatedDate}) => {
  const [progress, setProgress] = React.useState(0);
  React.useEffect(() => {
    const sidebar = document.querySelector('.guide-sidebar');
    if (!sidebar) return;
    let container = sidebar.parentElement;
    while (container && !container.querySelector('.guide-header')) {
      container = container.parentElement;
    }
    if (container && !container.classList.contains('guide-page-layout')) {
      container.classList.add('guide-page-layout');
    }
  }, []);
  React.useEffect(() => {
    const handleScroll = () => {
      const scrollTop = window.scrollY;
      const docHeight = document.documentElement.scrollHeight - window.innerHeight;
      const scrollPercent = docHeight > 0 ? scrollTop / docHeight * 100 : 0;
      setProgress(Math.min(100, Math.max(0, scrollPercent)));
    };
    window.addEventListener('scroll', handleScroll, {
      passive: true
    });
    handleScroll();
    return () => window.removeEventListener('scroll', handleScroll);
  }, []);
  const icon = category ? categoryIcons[category.toLowerCase()] || 'book' : 'book';
  return <aside className="guide-sidebar">
      <div className="guide-sidebar-content">
        <a href="/guides" className="guide-sidebar-back">
          <Icon icon="arrow-left" iconType="solid" size={14} />
          <span>All guides</span>
        </a>

        <div className="guide-sidebar-section">
          <div className="guide-sidebar-label">Progress</div>
          <div className="guide-sidebar-progress">
            <div className="guide-mascot">
              <svg viewBox="0 0 688 690" width="48" height="48">
                <defs>
                  <clipPath id="progressClip">
                    <rect x="0" y={0} width="688" height={progress * 6.9} />
                  </clipPath>
                </defs>

                {}
                <path d="M343.67 1.5C542.684 1.5 685.84 149.351 685.84 344.84C685.84 540.328 542.685 688.18 343.67 688.18C144.655 688.18 1.5 540.318 1.5 344.84C1.50007 149.361 144.655 1.50005 343.67 1.5Z" fill="#FCFCF7" stroke="#FF5FA2" strokeWidth="3" />

                {}
                <path d="M343.67 0C143.81 0 0 148.55 0 344.84C0 541.13 143.81 689.68 343.67 689.68C543.53 689.68 687.34 541.14 687.34 344.84C687.34 148.54 543.53 0 343.67 0Z" fill="#FF5FA2" clipPath="url(#progressClip)" />

                {}
                <path d="M337.89 319.29C337.89 336.75 322.49 350.14 302.81 349.83C286.18 349.57 273.89 337.29 274.37 321.45C274.88 304.82 290.91 290.88 309.98 290.44C325.69 290.09 337.88 302.69 337.88 319.29H337.89Z" fill="#4D122C" />
                <path d="M566.17 319.29C566.17 336.75 550.77 350.14 531.09 349.83C514.46 349.57 502.17 337.29 502.65 321.45C503.16 304.82 519.19 290.88 538.26 290.44C553.97 290.09 566.16 302.69 566.16 319.29H566.17Z" fill="#4D122C" />
                <path d="M367.74 342.07C360.22 346.32 359.4 354.9 370.62 366.4C381.85 377.9 399.76 389.56 420.81 389.18C441.88 389.1 460.67 377.72 472.47 363.53C473.83 361.93 478.84 356.88 478.51 351.07C478.32 348.35 476.17 341.19 467.83 341.38C463.46 341.44 461.21 343.68 456.69 347.36C445.2 356.14 432.7 361.21 420.56 361.27C408.43 361.43 395.68 356.17 385.39 347.22C380.32 342.81 375.25 337.82 367.74 342.07Z" fill="#4D122C" />
              </svg>
            </div>
            <span className="guide-sidebar-progress-text">{Math.round(progress)}%</span>
          </div>
        </div>

        {category && <div className="guide-sidebar-section">
            <div className="guide-sidebar-label">Category</div>
            <div className="guide-sidebar-category">
              <Icon icon={icon} iconType="solid" size={14} />
              <span>{category}</span>
            </div>
          </div>}

        {updatedDate && <div className="guide-sidebar-section">
            <div className="guide-sidebar-label">Last updated</div>
            <div className="guide-sidebar-date">{updatedDate}</div>
          </div>}

        {relatedLinks && relatedLinks.length > 0 && <div className="guide-sidebar-section">
            <div className="guide-sidebar-label">Related</div>
            <ul className="guide-sidebar-links">
              {relatedLinks.map((link, index) => <li key={index}>
                  <a href={link.href}>{link.title}</a>
                </li>)}
            </ul>
          </div>}
      </div>
    </aside>;
};

export const GuideTitle = ({title}) => {
  return <div className="guide-header">
      <h1 className="guide-title">{title}</h1>
    </div>;
};

<GuideSidebar
  categoryIcons={categoryIcons}
  category="modeling"
  updatedDate="December 2025"
  relatedLinks={[
{ title: "Measures", href: "/modeling/measures" },
{ title: "filters parameter", href: "/modeling/measures/parameters/filters" }
]}
/>

<GuideTitle title="Apply a filter to a single measure" />

Filtered measures allow you to apply a filter to a single measure in a given query. For example, filtered measures are equivalent to a SQL statement like:

```sql theme={null}
COUNT(DISTINCT
    CASE
      WHEN status = 'Complete' THEN order_id
      ELSE NULL
    END)
```

However, filtered measures have the added benefit of intelligent passing through the filter value when you drill.

## Option 1: Use the Create filtered measure workbook option

1. In a workbook query tab, create a query with a measure you want to filter.
2. Add a pivot on the dimension that contains the value you want to filter.
3. In the results table, right click on the measure you want to filter.
4. Select **Create filtered measure**.

<img src="https://mintcdn.com/omni-e7402367/Ueaby5Zd9SfduDZ-/guides/modeling/images/filtered-measure-option-1.gif?s=7a2a7fddfbb1303ed03650152edef554" alt="" width="1106" height="594" data-path="guides/modeling/images/filtered-measure-option-1.gif" />

## Option 2: Create a duplicate measure or a quick aggregate

1. In a workbook query tab, create a query with a measure you want to filter.
2. Create a new measure. You can do this by either right clicking on the field and selecting **Aggregates** or by duplicating an existing measure.
3. In the field browser, right click on the measure you just created and select **Modeling > Edit**.
4. In the **Edit field** panel, click **Add filter** to apply a filter to the measure.

<img src="https://mintcdn.com/omni-e7402367/Ueaby5Zd9SfduDZ-/guides/modeling/images/filtered-measure-option-2.gif?s=a2adc67b9298193d9739d3403e5654a3" alt="" width="1106" height="595" data-path="guides/modeling/images/filtered-measure-option-2.gif" />

## Option 3: Use the model IDE

You can also create filtered measures in the model IDE using [filter syntax](/modeling/measures/parameters/filters):

```yaml theme={null}
order_items_count_status_complete:
  aggregate_type: count
  filters:
    status:
      is: Complete

margin_sum:
  sql: ${order_items.margin}
  label: Completed Order Margin Sum
  aggregate_type: sum
  filters:
    status:
      is: Complete
```