# Trying to crate an avg of issue

**URL:** <https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968>\
**Category:** Questions & Answers\
**Created:** [July 6, 2022, 2:26pm UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968 "2022-07-06T14:26:02Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [July 18, 2022, 8:39am UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968/8 "2022-07-18T08:39:54Z")

</div>

Thanks.  
That is the real reason why you don’t have expected average results.

Please use **advanced settings** to define “Configuration issues” as a separate dimension. Then select to import new dimension in the eazyBI cube.  
See how to import numerical field as dimension: [Sprint Point Wise categorization - #3 by lauma.cirule](https://community.eazybi.com/t/sprint-point-wise-categorization/350/3)

Finally, use this formula for final your calculated measure:

```auto
[Measures].[Configuration issues created] 
/ 
Aggregate( 
	Except( 
	[Configuration issues].[Configuration issues].Members, 
	{ 
		[Configuration issues].[(none)]
	}),
	[Measures].[Issues created]
)

```

Martins / eazyBI

---

_[View the full topic](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968)._