Power Pivot Calculate measure with OR

[KimC2504]

Hi All,
Could I get some help with a power pivot calculate measure? I am trying to exclude all opportunites with either "Judgment" or "Mgt Adj". I have created the following formula:
=CALCULATE(sum(SFDC[Total]), SFDC[Version]="CW", OR(SFDC[Opportunity]<>"Mgt Adj",SFDC[Opportunity]<>"Judgment"))

The formula is not excluding the Mgt Adj or Judgment opportunities as I would like it to. Any suggestions would be appreciated.

 

[Ozeroth]

I think you just want to change your OR to an AND.
In other words, you want Opportunity both not equal to "Mgt Adj" and not equal to "Judgment":

=CALCULATE(sum(SFDC[Total]), SFDC[Version]="CW", AND(SFDC[Opportunity]<>"Mgt Adj",SFDC[Opportunity]<>"Judgment"))

Alternatively, you could use NOT(OR(...)) with = instead of <>:

=CALCULATE(sum(SFDC[Total]), SFDC[Version]="CW", NOT(OR(SFDC[Opportunity]="Mgt Adj",SFDC[Opportunity]="Judgment")))

Does that give the expected result?

 

[KimC2504]

Ozeroth, Thank u, that worked perfectly.