Sum of billed quantity for a particular month and year

[Nicky_12345]

Hi,

The below measure were created for sum of billed quantity for 2021 and 2022. Please advise how to create a measure for sum of billed  quantity for July 2022 and then another measure for August 2022. Thanks!

Billed Quantity 2021=

    CALCULATE(

        SUM('Append1'[Billed Quantity]),

        'Calendar'[Date].[Year] IN { 2021 }

    )

Billed Quantity 2022=

    CALCULATE(

        SUM('Append1'[Billed Quantity]),

        'Calendar'[Date].[Year] IN { 2022 }

    )

[lbendlin · Accepted solution]

You can "pile on" filters

Billed Quantity August 2022=

    CALCULATE(

        SUM('Append1'[Billed Quantity]),

        'Calendar'[Date].[Year] = 2022 ,

        'Calendar'[Date].[MonthNo] = 8

    )

[Nicky_12345]

Thank you so much! 🙂