[{"id":"840f0737-df1d-47ae-bb0a-359b01fe0608","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"d5d9cdef-8854-4505-89be-a2bbc3cb4482","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"3dc3dd55-35b0-4d23-bf62-47bc3650e4ee","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"80d84fbc-d0f8-4e4a-947f-e3e4de9b49b2","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"9152b7ca-0186-4fe3-a26f-5a05f322db07","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]}]
        
(Showing Draft Content)

AND

概述

检查两个参数是否均为 TRUE,如果两个参数都是 TRUE,则返回 1。 否则返回0。

语法

分析表达式

AND(<logical1>,<logical2>)

参数

参数

定义

logical1、logical2

要测试的逻辑值。

返回值

根据您测试的值的组合返回 1或 0。

示例

分析表达式

AND('Sale'[SaleAmount]>100,'Product'[Name]="Wyn")

备注

分析表达式中的 AND 函数只接受两 (2) 个参数。如果您需要对多个表达式执行 AND 运算,您可以创建一系列计算,或者更好的是,使用 AND 运算符 ( && ) 将所有表达式连接到一个更简单的表达式中。例如 :

AND('Sale'[SaleAmount]>100,'Product'[Name]="Wyn" && 'Category'[CategoryID]=1 ) 或 AND(AND('Sale'[SaleAmount]>100,'Product'[Name) ]="Wyn") ,'Category'[CategoryID]=1 )