Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter in SUMMARIZE function

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] )
    )
)
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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] )
            )

     

2 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    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] )
            )