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 th...
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]

  • Capono's avatar
    Capono
    Frequent Visitor
    8 years ago

    Thanks, for your time. This didn't work there should be a documentation how to use this.

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

      It'd be good if you could create an issue at Power BI Models GitHub.

      There're experienced developers who develop and support the Advanced Filter.

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • nhuzaa's avatar
        nhuzaa
        Frequent Visitor
        8 years ago

        I did try the above approach but its not working for me aswell.

        Where can I find proper documentation to implement

        IFilterMeasureTarget