Filter Summarized

[AllanBerces]

Hi and good day,

Can someone check and correct my below code. Im getting error of 

Oveall_MnHrs_Overview = FILTER(
SUMMARIZE('Table01',
'Table01'[Area],
'Table01'[Subcon] ,
'Table01'[Scope] ,
'Table01'[WeekNo.] ,
'Table01'[Year] ,
'Table01'[TA_rev] ,
"Current_Remaining", CALCULATE(SUM('Table01'[Remaining hours]),
"Actual_ForecastHRS", CALCULATE(SUM('Table01'[Actual_ForcastHRS])),
[TA_rev] = "ACTIVE"
&& [Year] = 2025
)))

Thank you

[DataNinja777 · Accepted solution]

Hi @AllanBerces ,

Your DAX formula contains several syntax issues that need to be addressed. Specifically, there are misplaced parentheses, incorrect handling of calculated columns within SUMMARIZE, and improper placement of filter conditions in the FILTER function. Below is the corrected version of your DAX formula:

Oveall_MnHrs_Overview = 
FILTER(
    SUMMARIZE(
        'Table01',
        'Table01'[Area],
        'Table01'[Subcon],
        'Table01'[Scope],
        'Table01'[WeekNo.],
        'Table01'[Year],
        'Table01'[TA_rev],
        "Current_Remaining", CALCULATE(SUM('Table01'[Remaining hours])),
        "Actual_ForecastHRS", CALCULATE(SUM('Table01'[Actual_ForcastHRS]))
    ),
    [TA_rev] = "ACTIVE" && [Year] = 2025
)

In this corrected version, the SUMMARIZE function groups the data by the specified columns (Area, Subcon, Scope, WeekNo., Year, and TA_rev) and creates two calculated columns: "Current_Remaining", which calculates the sum of Remaining hours, and "Actual_ForecastHRS", which calculates the sum of Actual_ForcastHRS. The FILTER function then filters this summarized table to include only rows where TA_rev equals "ACTIVE" and the Year equals 2025. This structure ensures that all syntax issues are resolved and the formula works as intended.

Best regards,

[AllanBerces]

Hi @DataNinja777 thank you you very much working great.