Distribution of calculate measure

Hello

How to calculate the distribution of calculate measure
I calculated a new value from requirement status
I called it “req status-customer requirement”
His calculation:

I calculated: :“inherit req status”
Order(
[Issue].[Issue].GetMembersByKeys([Measures].[Issue implemented by])
,
[Measures].[Requirement status - Num]
,
ASC).item(0).Get(‘Requirement Status’)

I calculated: :“req status - customer requirement” (based on inherit req status)
iif(IsEmpty([Measures].[inherit req status]),[Measures].[Issue Requirement Status],[Measures].[inherit req status])

Interested in seeing the distribution of “req status - customer requirement” values (it is not dimension)

Thanks
Shoshi

Hi,

I would assume that you have imported the Requirement Status dimension in your data cube and would like to see the number of issues in each status according to the logic of the “req status - customer requirement” formula.

If the Requirement Status dimension is in the report rows, the following formula should do that:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    ([Measures].[Issues created],
     [Requirement Status].DefaultMember)>0
    AND
    [Measures].[req status - customer requirement]=
    [Requirement Status].CurrentMember.Name
  )
)
)

Note to add the annotation for this formula to work with the drill-through issues:
-- annotations.drill_through_non_empty = false

Kindly,
Janis, eazyBI support

Hi Janis
Thank you very much