BasicFilterBuilder class

Power BI Basic 筛选器生成器组件

扩展

继承属性

target

方法

all()

将 Basic 筛选器的 All 设置为运算符


const basicFilterBuilder = new BasicFilterBuilder().all();
build()

创建基本筛选器


const basicFilterBuilder = new BasicFilterBuilder().build();
in((string | number | boolean)[])

设置基本筛选器的 In 作为运算符


const basicFilterBuilder = new BasicFilterBuilder().in([values]);
notIn((string | number | boolean)[])

将 NotIn 设置为基本筛选器的运算符


const basicFilterBuilder = new BasicFilterBuilder().notIn([values]);
requireSingleSelection(boolean)

设置基本筛选器所需的单选属性


const basicFilterBuilder = new BasicFilterBuilder().requireSingleSelection(isRequireSingleSelection);

继承的方法

withColumnAggregation(string, string, string)

使用列聚合目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withColumnAggregation(tableName, columnName, aggregationFunction);
withColumnTarget(string, string)

使用列目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withColumnTarget(tableName, columnName);
withHierarchyLevelAggregationTarget(string, string, string, string)

使用层次结构级别聚合目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withHierarchyLevelAggregationTarget(tableName, hierarchy, hierarchyLevel, aggregationFunction);
withHierarchyLevelTarget(string, string, string)

使用层次结构级别目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withHierarchyLevelTarget(tableName, hierarchy, hierarchyLevel);
withMeasureTarget(string, string)

使用度量值目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withMeasureTarget(tableName, measure);
withTargetObject(IFilterTarget)

使用目标对象设置筛选器的目标属性

const target = {
 table: 'table1',
 column: 'column1'
};

const filterBuilder = new FilterBuilder().withTargetObject(target);

继承属性详细信息

target

target: IFilterTarget

属性值

继承自FilterBuilder.target

方法详细信息

all()

将 Basic 筛选器的 All 设置为运算符


const basicFilterBuilder = new BasicFilterBuilder().all();
function all(): BasicFilterBuilder

返回

build()

创建基本筛选器


const basicFilterBuilder = new BasicFilterBuilder().build();
function build(): BasicFilter

返回

in((string | number | boolean)[])

设置基本筛选器的 In 作为运算符


const basicFilterBuilder = new BasicFilterBuilder().in([values]);
function in(values: (string | number | boolean)[]): BasicFilterBuilder

参数

values

(string | number | boolean)[]

返回

notIn((string | number | boolean)[])

将 NotIn 设置为基本筛选器的运算符


const basicFilterBuilder = new BasicFilterBuilder().notIn([values]);
function notIn(values: (string | number | boolean)[]): BasicFilterBuilder

参数

values

(string | number | boolean)[]

返回

requireSingleSelection(boolean)

设置基本筛选器所需的单选属性


const basicFilterBuilder = new BasicFilterBuilder().requireSingleSelection(isRequireSingleSelection);
function requireSingleSelection(isRequireSingleSelection?: boolean): BasicFilterBuilder

参数

isRequireSingleSelection

boolean

返回

继承的方法详细信息

withColumnAggregation(string, string, string)

使用列聚合目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withColumnAggregation(tableName, columnName, aggregationFunction);
function withColumnAggregation(tableName: string, columnName: string, aggregationFunction: string): BasicFilterBuilder

参数

tableName

string

columnName

string

aggregationFunction

string

返回

继承自FilterBuilder.withColumnAggregation

withColumnTarget(string, string)

使用列目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withColumnTarget(tableName, columnName);
function withColumnTarget(tableName: string, columnName: string): BasicFilterBuilder

参数

tableName

string

columnName

string

返回

继承自FilterBuilder.withColumnTarget

withHierarchyLevelAggregationTarget(string, string, string, string)

使用层次结构级别聚合目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withHierarchyLevelAggregationTarget(tableName, hierarchy, hierarchyLevel, aggregationFunction);
function withHierarchyLevelAggregationTarget(tableName: string, hierarchy: string, hierarchyLevel: string, aggregationFunction: string): BasicFilterBuilder

参数

tableName

string

hierarchy

string

hierarchyLevel

string

aggregationFunction

string

返回

继承自FilterBuilder.withHierarchyLevelAggregationTarget

withHierarchyLevelTarget(string, string, string)

使用层次结构级别目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withHierarchyLevelTarget(tableName, hierarchy, hierarchyLevel);
function withHierarchyLevelTarget(tableName: string, hierarchy: string, hierarchyLevel: string): BasicFilterBuilder

参数

tableName

string

hierarchy

string

hierarchyLevel

string

返回

继承自FilterBuilder.withHierarchyLevelTarget

withMeasureTarget(string, string)

使用度量值目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withMeasureTarget(tableName, measure);
function withMeasureTarget(tableName: string, measure: string): BasicFilterBuilder

参数

tableName

string

measure

string

返回

继承自FilterBuilder.withMeasureTarget

withTargetObject(IFilterTarget)

使用目标对象设置筛选器的目标属性

const target = {
 table: 'table1',
 column: 'column1'
};

const filterBuilder = new FilterBuilder().withTargetObject(target);
function withTargetObject(target: IFilterTarget): BasicFilterBuilder

参数

target
IFilterTarget

返回

继承自FilterBuilder.withTargetObject