Dimension filtering, two definitions

[One_day_I_will_know]

Hi all,

I manage to filter dimensions when I only need one definition, for example:

=if(Customers.Area='North', [Customers.Tier],Null())

I've tried to figure out how to add another definition but haven't succeeded. For example this doesn't work: 

=if(Customers.Area='North' and Customers.Tier = 'New',  [Customers.Tier],Null())

Would somebody please tell me how to do it properly?

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

=if(Customers.Area='North', If(Customers.Tier = 'New',  [Customers.Tier],Null()))

[One_day_I_will_know]

It indeed is - thank you for the quick reply!