Skip to main content

Power BI

Needs Votes

Page and report level filters on a measure

Vote (1029) Share
Merijn Campsteyn's profile image

Merijn Campsteyn on 18 Apr 2016 02:18:42

I would like to be able to apply page or report level filters on a measure. E.g. say you have a set of supplier transactions and you want to keep those suppliers where the total value of the records is above a certain amount.

Currently it's not possible to drag a measure to the filters pane and when you apply the filter on a value field it wil filter each individual record instead of the total value.

Comments (65)
Merijn Campsteyn's profile image Profile Picture

HOLLIE A JAMBRETZ on 05 Jul 2020 23:58:13

RE: Page and report level filters on a measure

In the university setting, there are many uses for a report filter being based on a measure. I

Merijn Campsteyn's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:57:52

RE: Page and report level filters on a measure

Nearly three and a half years on, there's still no response to this!!

Merijn Campsteyn's profile image Profile Picture

Wildmight on 05 Jul 2020 23:16:07

RE: Page and report level filters on a measure

This would help to resolve this:
https://community.powerbi.com/t5/Desktop/Measure-as-Page-Level-Filter/m-p/382674#M174140

Merijn Campsteyn's profile image Profile Picture

Alex Rajkov on 05 Jul 2020 23:10:18

RE: Page and report level filters on a measure

Yes, really Important request for creating user based views like e.g. my team page/KPI‘s, not „hard RLS filtering. Today you will have to create New measures including a username based filter...its to much effort

Merijn Campsteyn's profile image Profile Picture

Mark David Gaal on 05 Jul 2020 22:26:31

RE: Page and report level filters on a measure

agreed, I have a dataset that appends each time on export and for SOME of my visualizations (on a page) I would like for the data to represent the MAX(Export Date Field)