Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Reuben
Helper III
Helper III

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

Sin título.png

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] )
    )
)
1 ACCEPTED SOLUTION
v-eachen-msft
Community Support
Community Support

Hi @Reuben ,

 

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

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

2 REPLIES 2
v-eachen-msft
Community Support
Community Support

Hi @Reuben ,

 

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

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.