Calculate Orders with and without specific items

Hey! It is already friday and i try to finish my report, but i can not solve or create the correct measure for the following Request: - Summarize all orders without transport costs - list a...

Need Help

v-chuncz-msft

9 years ago

DennisJung,

You may use the following DAX to add a measure.

Measure =
SUMX (
    FILTER (
        Table1,
        NOT (
            CONTAINS (
                Table1,
                Table1[Ordernumber], Table1[Ordernumber],
                Table1[article], 90
            )
        )
    ),
    Table1[value]
)

v-chuncz-msft

Community Support

9 years ago

DennisJung,

You may use the following DAX to add a measure.

Measure =
SUMX (
    FILTER (
        Table1,
        NOT (
            CONTAINS (
                Table1,
                Table1[Ordernumber], Table1[Ordernumber],
                Table1[article], 90
            )
        )
    ),
    Table1[value]
)

DennisJung

Helper I

9 years ago

Worked! Thank you very much!

Forum Discussion

Calculate Orders with and without specific items