Filter a measure column using AdvanceFilter

It seems you can use column target instead of measure.

Have you tried such solution?

const min: number = 100;
const max: number = 101;

if (!this.dataView) {
    return;
}

const source = this.dataView.categorical.values[0].source;

let conditions: IAdvancedFilterCondition[] = [];

if (min) {
    conditions.push({
        operator: "GreaterThan",
        value: min
    });
}

if (max) {
    conditions.push({
        operator: "LessThan",
        value: max
    });
}

const query: string[] = /\((\w+).(\w+)\)/.exec(source.queryName);

let target: IFilterColumnTarget = {
    table: query[1],
    column: query[2],
};

let filter: IAdvancedFilter = new window['powerbi-models'].AdvancedFilter(target, "And", conditions);
this.host.applyJsonFilter(filter, "general", "filter", FilterAction.merge);

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

[email protected]