Forum Discussion
Filtering a page based on a measure
I am building a two-page report in desktop with the first page showing summary project figures - count of customers, total sales, mean sales per month etc. - while the second page needs to show the same measures restricted to the team for the logged in user.
If I apply role based filtering, both pages get filtered and so show only the figures for the logged in user's team, but I can't apply page level filtering based on a dynamic value ..... so I guess I am missing something in how to solve this problem in Power BI.
In effect, I want to set the page level filter to be "MyTeam" where "MyTeam" is the name of a measure.
Any help much appreciated.
Hi BeeBeeJay,
Until now, we can't add measure in Page level filter, please review this feature request and vote it.
Best Regards,
Angelia
4 Replies
Hi BeeBeeJay,
Until now, we can't add measure in Page level filter, please review this feature request and vote it.
Best Regards,
AngeliaThanks for highlighting that. Have voted for it.
You might be able to solve that with the disconnected table trick.
Yes, until now you cannot apply measure filter on the page level.
Here a great video on how to use measure filters:
https://www.youtube.com/watch?v=Ss5L7jXIhso
