Здравствуйте, подскажите как мне подкорректировать мою формулу, чтобы работали оба исключения --первое работает, а второе нет(
Код |
---|
Memberships BOGO_0 = CALCULATE(COUNT('boulevardapi sales'[MEMBER]), NOT 'boulevardapi sales'[MEMBER product name] IN { "LTL Membership","AMBASSADOR MEMBERSHIP","DeleTE","Membership Backdate Charge","DELETe","AMBASSADOR MEMBERSHIP 2","AMBASSADOR MEMBERSHIP 1"}, NOT 'boulevardapi sales'[MEMBER] IN { "Test User","Test Test23","test test"} |
вот это не срабатывает через запятую :
Код |
---|
, NOT 'boulevardapi sales'[MEMBER product name] IN { "LTL Membership","AMBASSADOR MEMBERSHIP","DeleTE","Membership Backdate Charge","DELETe","AMBASSADOR MEMBERSHIP 2","AMBASSADOR MEMBERSHIP 1"}, NOT 'boulevardapi sales'[MEMBER] IN { "Test User","Test Test23","test test"} |