I filter issues by a customized variable “Web Site”:
Aggregate({
[Web Site].[A],
[Web Site].[B],
[Web Site].[C],
[Web Site].[D]
})
but if I have 1 ticket only, with 2 values in Web Site, using “Issue Closed” I get 2 and not 1 as expected.
I filter issues by a customized variable “Web Site”:
Aggregate({
[Web Site].[A],
[Web Site].[B],
[Web Site].[C],
[Web Site].[D]
})
but if I have 1 ticket only, with 2 values in Web Site, using “Issue Closed” I get 2 and not 1 as expected.
Hi,
That indeed is the behavior with the dimension members imported from multi-value custom fields.
In those cases, we would recommend using distinct measures to return each issue just once.
Martins / eazyBI support.
Wow, that works!!
I have realized now there are “count” measures
Thank you so much Martins