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 (65)
RE: Page and report level filters on a measure
spotted a complex workaround which might be of use to someone...
https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
RE: Page and report level filters on a measure
Any update? How is this still not possible...?
RE: Page and report level filters on a measure
Yes please.
RE: Page and report level filters on a measure
Still early in my Power BI journey and came across this need. Would be nice to have OOB as it was easy to create the measure but YoY measures struggle when you have data in previous years but not the current so each visual has to be filtered instead of the page (or better yet, all the pages).
Other option is to update the Quick Measure create to remove the value if the calculation for YoY returns Blank.
RE: Page and report level filters on a measure
As others have said, this request has been around a long time, but I guess its down to votes. From a User usability perspective it would make things so much easier and cleaner, imo.
RE: Page and report level filters on a measure
I wonder how many votes are needed to consider something an important user ask... It has been sitting since 2016 now, and in 2021 we still get people asking for it. It would be so nice...
RE: Page and report level filters on a measure
This would be really useful - I have to apply a measure filter to every visual on every page of a report. This then confuses the average consumer who wants to be able to filter the whole page
RE: Page and report level filters on a measure
Has anyone found a way around this?
RE: Page and report level filters on a measure
This is a need. Has anyone found a work around?
RE: Page and report level filters on a measure
Need this functionality urgently!!