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

b2b9291b 96ee-4d52-8079-fa49c2c6f1a8 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

b63102fc edd4-41e8-beae-94bad2936baa 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

a10afd74 b53f-4778-8f2d-d9c3cf65ca31 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)