Fabric Plan Community Logo
Sign in

COUNT

The COUNT function returns the number of values in a list by counting the values provided in the arguments. It accepts numeric values or node references and is commonly used to determine the size of a dataset or the number of entries in a range.

Syntax

COUNT(value1, value2, ...)

Arguments

  • value1, value2, ...: A list of values or node references to count.

Return value

Returns the count of values in the list.

Example

COUNT(FILTERIF([2024 Actuals, 2025 Actuals, 2026 Actuals], ">0"))

In this example, the COUNT function returns the count of values greater than 0 in 2024 Actuals, 2025 Actuals, and 2026 Actuals.

Excel equivalent

COUNT

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.