SUMX Totals in matrix not correct with if-condition on lowest level

[KenLucaaaaaa]

Hi, I want to check on a customer-article-month level, if an artcile was out-of-stock and if not out-of-stock, then write a 1.

This 1 I want to add up then per customer-article-month combination.

Currently I get the following matrix:

 But what I want is the following:

So in this case it is filtered for 6 customers, that's why in the matrix there is always a 6 when the article is not out-of-stock. But the totals are not correctly calculated, both for rows and for columns. What am I doing wrong?

Thanks! 🙂

OOS ja/nein =

SUMX(

    VALUES(D_Date[MonatID]),

    SUMX(

        VALUES(D_Products[Product_Description]),

        SUMX(

            D_Kunde,

            IF(

                SUM(F_OutofStockHistory[AnzahlTageOoS]) > 0,

                0,

                1

            )

        )

    )

)

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...