Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Parent & child Hierarchy displaying address(text value)

I am in a situation, where I have displayed the addresses of both parent and child (4 levels). I am getting addresses for parent and child by writing measure (child addresses are correct but for parents when I use Max or Min of text value(address) which is wrong).

Community Support
Community Support

Hi @Subbu43 ,


What does your source data look like? What do you want to display in the Parent level address? It is difficult to infer your raw data based only on the information provided by visual and measure.

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.


Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly


Best Regards,

Jianbo Li

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

Frequent Visitor

As you can see Parent does not show the address.

Measure used for display Address(street) as below

AL.Street =
IF (
    Accounts[BrowseDepth] <>Accounts[EntityRowDepthM]  ,
   if(Accounts[BrowseDepth] == Accounts[EntityRowDepthM],MAX(Accounts[BillingStreet])),


Solution Sage
Solution Sage

Sorry, having trouble following, can you post sample data as text and expected output?
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data

Below is the link for the pbix files

Please find the attachment.
As you can see in the file attached, the Street for Parent is not displayed. The street is displayed only for child.
My requirement is to display the street and city for both parent and child, how many level at may be.

Thanks in advance

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors