Filterconditions wrapped in a summarize() calculated table not filtering correctly

[Applicable88]

Hello,

I have a facttable and I want to filter and group it at the same time. I wrote following calculated table function:

Summarize = SUMMARIZE('Facttable',Table1[Materialnumber,"count",CALCULATE(COUNT('Facttable[Order]),'Facttable'[Ordertype] in {"3BLL","3PP"} ,NOT(CONTAINSSTRING('FAIS'[Typestatus],"Delivered")),'Facttable'[Status] <> "finished",'Facttable'[Category] <> "Planned"))

As you can see there are quite some conditions.

Afterwards for example I put every column in a table where I can double check with the powerbi filterpane if everything filtered out correctly. And its not. For example there are still "Planned" orders in the column Category in my new calculated table, whereas the function should filtered all which are not "Planned".  Also other filters also haven't filtered the other conditions correctly

The syntax was right, but why the summarized table isn't filtered correctly? Is it not possible to filter things out this way?

Which syntax is more appropriate for that kind of filtering?

Thank you very much in advance.

Best.

[Icey]

Hi @Applicable88 ,

I create a sample for test. And there is no issue. Please check if there is any difference compared to your scenario.

Summarize =
SUMMARIZE (
    'Facttable',
    Table1[Materialnumber],
    "count",
        CALCULATE (
            COUNT ( 'Facttable'[Order] ),
            'Facttable'[Ordertype] IN { "3BLL", "3PP" },
            NOT ( CONTAINSSTRING ( 'FAIS'[Typestatus], "Delivered" ) ),
            'Facttable'[Status] <> "finished",
            'Facttable'[Category] <> "Planned"
        )
)

Best regards

Icey

If this post helps,then please consider accepting it as the solution to help other members find it more quickly.