Power BI - The syntax for ')' is incorrect

Thanks. I've taken that on board and the formula is working now.

awalker2009 Those can't be the full formulas as you are using VAR statements without a RETURN statement.

Hello awalker2009,

The error message "The syntax for ')' is incorrect" in your DAX measure is caused by the way filters are being applied within the CALCULATE function. In DAX, filters inside CALCULATE must be valid Boolean expressions or table filters. Expressions such as Data[Start Date] <= lastqtrdate must be wrapped in a FILTER function to be valid.

Please, try it:

Nos Supported =
VAR lastqtrdate = MAX(Quarters[Qtr End Date])
VAR firstqtrdate = MIN(Quarters[Qtr Start Date])
RETURN
CALCULATE(
    COUNTROWS(Data),
    FILTER(
        Data,
        Data[Start Date] <= lastqtrdate &&
        Data[End Date] >= firstqtrdate
    )
)

CALCULATE – DAX Guide

✅ If this response resolved your issue, please mark it as correct to assist other members of the community.

Hi awalker2009 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@danextian sevenhills GeraldGEmerick Zanqueta  Thank you so much for your inputs.

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.