Is IT possible to get the report page name by using DAX

[v-sabgup]

Hi All

Is there is any way to get the Page Name via DAX.

Reason for this ask : At present we are displaying the Read me count for all the pages which discribe about the page information. 

Problem Statement : In case of any new pages is added to the report we need to modify the DAX by adding a condition.

Solution Required : If we can able to get the page name via DAX then we dynamically pass the pagename in the filter and that will reduce our manual changes and it will me more useful.

As per the requirment i want to diplay some business content which describe about the page. Which help the user to understand about the page and how the business is running. To acheive that we are using a DAX to display information.

DAXForloadingPlaceholder =

var test = CALCULATE(distinct(Sheet1[Placeholder]),FILTER(Sheet1,Sheet1[Tabname]="A1"))

var userName1=USERPRINCIPALNAME ()

var salesAmount=sum(Sheet2[Sales])

var test1 = SUBSTITUTE(test,"DAX1",userName1)

var test2=SUBSTITUTE(test1,"DAX2",salesAmount)

var test3=SUBSTITUTE(test2,"DAX3",year(TODAY()))

var test4=SUBSTITUTE(test3,"DAX4","Sales Team")

return test4

We have build a similar information by passing filter as hardcoded value . 

For a demo

[v-henryk-mstf]

Hi @v-sabgup ,

This requirement seems a bit specific, I don't think you can get the name corresponding to the REPORT by creating a dax in the powerbi desktop, which doesn't have much of a real business scenario.

However, if the report is published to the service, you can get the information about the report through the rest api, and one of the parameters is the report name.

for example:

GET https://api.powerbi.com/v1.0/myorg/reports/879445d6-3a9e-4a74-b5ae-7c0ddabf0f11/pages

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@v-sabgup not really clear what you are looking for? Any example/screenshot will help to understand the problem.