Trying to crate an avg of issue

Questions & Answers
8

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

Finally, use this formula for final your calculated measure:

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

Martins / eazyBI