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

Thijs Leufkens on 06 Jul 2020 00:04:08

RE: Page and report level filters on a measure

This would make custom relative date filters so much easier...

Merijn Campsteyn's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:03:48

RE: Page and report level filters on a measure

I would like to be able to filter pages based on measures - especially if they are text type.

Merijn Campsteyn's profile image Profile Picture

Roben on 06 Jul 2020 00:03:24

RE: Page and report level filters on a measure

let's dooo iiiiitttt

Merijn Campsteyn's profile image Profile Picture

Jaime Morton on 06 Jul 2020 00:01:48

RE: Page and report level filters on a measure

Needed!!

Merijn Campsteyn's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:01:41

RE: Page and report level filters on a measure

Please

Merijn Campsteyn's profile image Profile Picture

Daniel Olivas on 05 Jul 2020 23:59:25

RE: Page and report level filters on a measure

Wow, this goes back over 3.5 years? How come this hasn't been implemented, yet?

Merijn Campsteyn's profile image Profile Picture

DamienK on 05 Jul 2020 23:59:23

RE: Page and report level filters on a measure

I wanted to create a measure that represent X% of the global revenue and display a chart based on this measure.
I have sometime the case.

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