Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Page and report level filters on a measure

    Vote (1000) 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 (64)
    Merijn Campsteyn's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:04:39

    RE: Page and report level filters on a measure

    please

    Merijn Campsteyn's profile image Profile Picture

    Becky Conning on 06 Jul 2020 00:04:08

    RE: Page and report level filters on a measure

    This would be great. The way I envision this feature is as by dragging a measure to the filter field then being prompted to select other columns by which the measure should be grouped.

    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