PowerBI DAX FILTER多条件过滤
2019-10-30 本文已影响0人
青山白衣
FILTER多条件过滤
measure = CALCULATE(
DISTINCTCOUNT('talbe'[column]),
FILTER('talbe','talbe'[column]<>"abc"),//<>匹配不等于
FILTER('talbe','talbe'[column]=FALSE())//=匹配等于
)
FILTER多条件过滤
measure = CALCULATE(
DISTINCTCOUNT('talbe'[column]),
FILTER('talbe','talbe'[column]<>"abc"),//<>匹配不等于
FILTER('talbe','talbe'[column]=FALSE())//=匹配等于
)