Filter on Calculate Sum

Hi All, I am trying to do the below calculation to sum the Annual GP based a couple of filters, but as soon as I try and do the filter actualclosedate>X then it doesn't work and just sums all Ann...

Need Help

MFelix

6 years ago

Hi Anonymous ,

Try this measure:

AGP Removed =
CALCULATE (
    SUM ( Opportunity[Annual GP] ),
    (Opportunity[new_ContractType] = 279640002
        || Opportunity[new_ContractType] = 279640000
        || Opportunity[new_ContractType] = 957500000) &&
    Opportunity[ActualCloseDate] > DATE( 2020, 1, 15)
)

Forum Discussion

Filter on Calculate Sum

Related content

Filtering a Sum

Calculate sum without filters

Calculating with Filters

Filter and Sum

Calculate Sum FILTER