Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

calculated measure as filter

hi

why there is no option to set our own calculated measure as page filter in direct query mode?

i try to find an idea about it but didn't find..

 

is somebody knows?

 

thanks a lot!

Need Help

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    MP_123

     

    In Power BI, the page level filter is without aggregating. It does this because a page can have many visuals which can each utilize different aggregation types. However, the measure is always aggregating the column data so that you can't put it into page level filter. For your requirement, I suggest you make your calculation in your data source so that this "calculated measure" can be a field in your dataset. Then you can just put this field into Page Level filter. 

     

    Reference:
    Add a filter to a report in Power BI

     

    Regards,

    • MP_123's avatar
      MP_123
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      v-sihou-msft

       

      thanks!

      actually visual filters are not supported also with calculated measure.

      youre right about the measure in my data source but you know that sometimes there are calculated that you have to create in the pbi file. for example dax function if,so.. or for some visualiztions tricks.

       

      thanks for your help!