Skip to main content

Power BI

Needs Votes

Page and report level filters on a measure

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

f007843a 3297-43ca-8568-cf6f10470cd9 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

7d121223 ce43-47c4-bfac-69ac7b8c015f 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

6345de73 e281-4987-9ef7-a3ae59f4799f 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

e2ed94e2 60f7-459e-b59a-9f49f085e00b on 06 Jul 2020 00:01:48

RE: Page and report level filters on a measure

Needed!!

Merijn Campsteyn's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:01:41

RE: Page and report level filters on a measure

Please

Merijn Campsteyn's profile image Profile Picture

0d4b807a e1f5-4620-972c-66226c0ef96d 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

d5c46788 0541-425c-907d-a096a02fa483 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

1abdb7b7 7d09-401f-8cd1-56ca25e4aacb 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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!!