Skip to main content
Microsoft Idea

Power BI

Needs Votes

Page and report level filters on a measure

Vote (1002) 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 (62)
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)