calculated measure as filter

[MP_123]

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!

[v-sihou-msft]

@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]

@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!