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