Filtering a page based on a measure

[BeeBeeJay]

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.

[v-huizhn-msft · Accepted solution]

Hi @BeeBeeJay,

Until now, we can't add measure in Page level filter, please review this feature request and vote it.

Best Regards,
Angelia

[BeeBeeJay]

Thanks for highlighting that.  Have voted for it.

[Greg_Deckler]

You might be able to solve that with the disconnected table trick.

https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...