sum filtering by multiple criteria using calculate and contains.

Question

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&nbsp;WR SUM CLAIMQ = CALCULATE (&nbsp; &nbsp; SUM ('WARRANTY RATE'[CLAIM Q]),&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ALL ( 'WARRANTY RATE' ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CONTAINS (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VALUES ( 'WARRANTY RATE'[DATE_REFERENCE] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'WARRANTY RATE'[DATE_REFERENCE],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'WARRANTY RATE'[DATE]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp;))&nbsp;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 Answer

Anonymous&nbsp;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]
            )
       )
)

Forum Discussion

sum filtering by multiple criteria using calculate and contains.

1 Reply

Related content

Visual calculation- Contain

Calculating with Filters

Calculate Filters

Contain Word

How to search specific word in table filter Calculations