# Add property or measure to Hierarchy created from

**URL:** <https://community.eazybi.com/t/add-property-or-measure-to-hierarchy-created-from/10485>\
**Category:** Questions & Answers\
**Tags:** data-mapping, dataimport, customhierarchy, hierarchy\
**Created:** [September 5, 2022, 2:28pm UTC](https://community.eazybi.com/t/add-property-or-measure-to-hierarchy-created-from/10485 "2022-09-05T14:28:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ronak\_kc](https://community.eazybi.com/letter_avatar_proxy/v4/letter/r/fbc32d/32.png) [@ronak\_kc](https://community.eazybi.com/u/ronak_kc)\
**Post date:** [September 5, 2022, 2:28pm UTC](https://community.eazybi.com/t/add-property-or-measure-to-hierarchy-created-from/10485/1 "2022-09-05T14:28:06Z")

</div>

Hi,

I’ve created a custom hierarchy in EazyBI :

Director =\> Manager =\> Team Leader

I’m importing data using an Excel file as shown:

 ![Employee question screen 3](https://community.eazybi.com/uploads/default/original/2X/b/b84e76414458247e21f32f561474a299847eb44f.png)

This is the mapping I’m using:

 ![Employee question screen 4](https://community.eazybi.com/uploads/default/original/2X/2/2e8e351a31099ae008eef34ae1a70535f6a6ab76.png)

Is there a way for me to add new measures to define parameters for the Employees in the hierarchy as shown below?

 ![Employee question screen 2](https://community.eazybi.com/uploads/default/original/2X/0/0774d0e06d43552ecb65cd1e95a83042d186260b.png)

Thanks!

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [September 19, 2022, 10:36am UTC](https://community.eazybi.com/t/add-property-or-measure-to-hierarchy-created-from/10485/2 "2022-09-19T10:36:16Z")

</div>

Hi @ronak_kc ,  
You can import in similar manner property for each level (there would be three additional columns) - Director ID, Manager ID and Team Leader ID.  
After the import, you can consolidate all IDs in one measure using this expression to show needed ID at each level:

```auto
CASE [Employee].CurrentHierarchyMember.Level.Name
  WHEN "(All)" THEN ""
  WHEN "Director" THEN [Employee].CurrentHierarchyMember.Get('Director ID')
  WHEN "Manager" THEN [Employee].CurrentHierarchyMember.Get('Manager ID')
  WHEN "Team leader" THEN [Employee].CurrentHierarchyMember.Get('Team Leader ID')
END

```

In the report:

 ![eazyBI_employee_ID](https://community.eazybi.com/uploads/default/original/2X/e/e7d0f0874ae012886fffb8e8ccabf246da6e54af.jpeg)

best,  
Gerda // [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![ronak\_kc](https://community.eazybi.com/letter_avatar_proxy/v4/letter/r/fbc32d/32.png) [@ronak\_kc](https://community.eazybi.com/u/ronak_kc)\
**Post date:** [September 19, 2022, 1:18pm UTC](https://community.eazybi.com/t/add-property-or-measure-to-hierarchy-created-from/10485/3 "2022-09-19T13:18:34Z")

</div>

Thank you @gerda.grantina . This worked out for me.