Forum Discussion

Capono's avatar
Capono
Frequent Visitor
8 years ago

Advance Filter on Measures with IFilterMeasureTarget

 

Hi, I was trying to implement the advance filter as shown for the sampleSlicer for API 1.7.0. This works great.

 

My question is now is it also possible to filter on measures, since I found the target IFilterMeasureTarget for the target value. If yes what do I have to put for table and measure for the target values?

 

 

Looking forward to an answer, thanks.

 

With Regards

 

Asamah

7 Replies

  • v-viig's avatar
    v-viig
    Community Champion
    8 years ago

    Hello Capono

     

    I think that you should use something like this:

    let valueColumn: DataViewValueColumn = this.dataView.categorical.values[0];

let target: IFilterColumnTarget = {
    table: valueColumn.source.queryName.substr(0, valueColumn.source.queryName.indexOf('.')),
    column: valueColumn.source.displayName
};

return target;

    Please let me know if this code resolves the issue.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

    • Capono's avatar
      Capono
      Frequent Visitor
      8 years ago
      Hi,
      thanks .
      This works only if the measures are not aggregated, i already tried that and this works only if you have the correct table name and the correct column name which is not the case on aggregated values. I was hoping to be able on Filterung by a aggregated measures with .IFilterMeasureTarget.
      • v-viig's avatar
        v-viig
        Community Champion
        8 years ago

        Have you tried something like this?

        let valueColumn: DataViewValueColumn = this.dataView.categorical.values[0];

let target: IFilterMeasureTarget = {
    table: valueColumn.source.queryName.substr(0, valueColumn.source.queryName.indexOf('.')),
    measure: valueColumn.source.queryName,
};

return target;

        Please let me know if that works. Otherwise, it'd be better to create a question at powerbi-models GitHub repository.

         

        Ignat Vilesov,

        Software Engineer

         

        Microsoft Power BI Custom Visuals

        [email protected]