# Show info based on Measure only

**URL:** <https://community.eazybi.com/t/show-info-based-on-measure-only/14413>\
**Category:** Questions & Answers\
**Tags:** mdx\
**Created:** [November 30, 2023, 12:01am UTC](https://community.eazybi.com/t/show-info-based-on-measure-only/14413 "2023-11-30T00:01:42Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [December 11, 2023, 9:22am UTC](https://community.eazybi.com/t/show-info-based-on-measure-only/14413/2 "2023-12-11T09:22:17Z")

</div>

Hi @Tacoman  
Your calculation is referencing `[Reporter Location from AD].CurrentMember.Name` and, thus, the location will be visible only when you have the full list of your “Reporter Location from AD” dimension members in rows. You could create separate calculated members in the “Reporter Location from AD” dimension, but the report will have some performance issues with _MATCHES_ and 140+ locations.

The best would be using [additional import](https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube#AdditionaldataimportintoJiraIssuescube-Mappingtosinglevaluecustomfielddimensions) and adding a custom property to your field “Reporter Location from AD.” You can create a **custom hierarchy in your custom field based on the property**. Here you can read more about it in our documentation: [Custom hierarchies](https://docs.eazybi.com/eazybi/analyze-and-visualize/custom-hierarchies)  
This will allow you to aggregate your values in the “Reporter Location from AD” dimension, and then you can select measures from the “Measures” dimension to see the values per each location.

Here is an example from the eazyBI Community using the “Assignee” dimension:

> [@How to create a Team of assignees](https://community.eazybi.com/t/how-to-create-a-team-of-assignees/3012/6):
>
> Hi there, Since eazyBI version 6.1 and on eazyBI Cloud there is an option to [create a custom hierarchy](https://docs.eazybi.com/eazybi/analyze-and-visualize/custom-hierarchies) in the Assignee, Reporter, Logged by, project and Sprint dimensions. How this could be a solution for your use case? You can create a new hierarchy and group users by user teams in the Assignee dimension. Import team information as Assignee property. You can do this with [additional data import](https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube) from Google Sheets, XLS file, REST API or SQL SELECT to some database. The implementation of addit…

The difference will be that you need to add [additional settings for the single select custom field](https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube#AdditionaldataimportintoJiraIssuescube-Mappingtosinglevaluecustomfielddimensions) so it will appear in the additional data import.

Best,  
Gerda // [support@eazybi.com](mailto:support@eazybi.com)

---

_[View the full topic](https://community.eazybi.com/t/show-info-based-on-measure-only/14413)._