Using the Page Name in a new measure

[pharvey7]

I've incorporated an idea from an earlier post, where a field can be used interactively in a title (e.g. = "Graph for " & IF(HASONEVALUE('table1'[column1]),VALUES('table1'[column1]),"<Text>").

I would like to go a step further and use the page name, so that I can use the same measure across other pages. So if I renamed the page to "Graph", I could replace the above example with = 'Graph ' & "for " & IF(HASONEVALUE('table1'[column1]),VALUES('table1'[column1]),"<Text>").

So if I had another page with a table of data, it would read: = 'Table ' & "for " & IF(HASONEVALUE('table1'[column1]),VALUES('table1'[column1]),"<Text>").

My question therefore, is how can I use the page name in this example?

[andrewbrick]

You could create a table with column names corresponding to each page and one row of dummy values of "1" for each column.  Then, on each page, create a page-level filter to filter the corresponding column in that table (basic filtering, select "1" from the list of values).  Then, in your measure, use IF(ISFILTERED(PageNames[PageName1]),"Page Name 1", IF(ISFILTERED(PageNames[PageName2],"Page Name 2",...)).  The ISFILTERED function will return true/false (and therefore the active page name you type in) based on the page you're on, in turn based on the page-level filters you've set on each page.

This solution won't respond to changes made to the page names on the tabs along the bottom.  You'd have to change the text returned by the IF(ISFILTERED()) bit to correspond to page name changes.

[andrewtuplin]

This assumes the user wouldn't change the page level filters (which they could easily do). 

[andrewbrick]

Unless you hide this particular page-level filter...

[v-frfei-msft · Accepted solution]

Hi @pharvey7,

Based on my test, it is not possible to meet your requirement currently. You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

Regards,

Frank