sum filtering by multiple criteria using calculate and contains.

[Anonymous]

hello, I am trying to create a measure that calculates the sum of a column based on the amount 3 months before.
I have managed to calculate it with the following measure creating a reference date column that shows the 3 previous month date

WR SUM CLAIMQ =

CALCULATE (

    SUM ('WARRANTY RATE'[CLAIM Q]),

    FILTER (

           ALL ( 'WARRANTY RATE' ),

           CONTAINS (

                     VALUES ( 'WARRANTY RATE'[DATE_REFERENCE] ),

                              'WARRANTY RATE'[DATE_REFERENCE],

                               'WARRANTY RATE'[DATE]

            )

       )

)

my problem is that i need to add an extra filter to the measure to do the calculation by countries( present in a column in the same table ). so that it can be filtered using a slicer in the report.

can someone help me to find a way to include this filter?

[Greg_Deckler · Accepted solution]

@Anonymous Maybe:

WR SUM CLAIMQ =
VAR __Country = MAX('WARRANTY RATE'[COUNTRY])
CALCULATE (
    SUM ('WARRANTY RATE'[CLAIM Q]),
    'WARRANTY RATE'[COUNTRY] = __Country,
    FILTER (
           ALL ( 'WARRANTY RATE' ),
           CONTAINS (
                     VALUES ( 'WARRANTY RATE'[DATE_REFERENCE] ),
                              'WARRANTY RATE'[DATE_REFERENCE],
                               'WARRANTY RATE'[DATE]
            )
       )
)