Filter in SUMMARIZE function

[Anonymous]

Hi all,

In my measure, i want to exclude from the calculation the column "Line C" , but I don´t know wherte to put the filter TableLines[Line] <> "Line  C". Any ideas?

Thank you very much for your help

YTD OEE =
CALCULATE (
    DIVIDE (
        SUMX (
            SUMMARIZE (
                TableLines;
                TableLines[Line];
                "AA"; [Total Units] / ( [Opening Time H] * [Speed units hour] )
            );
            [AA] * [Opening Time H]
        );
        [Opening Time H];
        0
    );
    DATESYTD ( Calendar[Date]; "30/06" );
    FILTER (
        ALL ( 'Calendar' );
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
            && 'Calendar'[Fiscal Year] = MAX ( 'Calendar'[Fiscal Year] )
    )
)

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You can add it in the "SUMMARIZE" part.

SUMMARIZE (
                FILTER(TableLines;TableLines[Line] <> "Line  C");
                TableLines[Line];
                "AA"; [Total Units] / ( [Opening Time H] * [Speed units hour] )
            )

[Anonymous]

@v-eachen-msft Thank you very much!!