Custom Measure based Custom Cascade field Parent and Child

Questions & Answers
1

I have a report that is made up of a cascading field that I want to get percentage based not eh Parent Value / Child Value of issues resolved

EazyBI-1
EazyBI-1.png1401×874 64.3 KB

In this case it would be "Core Dealer Experience (Child) / Product which is the parent of issues resolved

I am looking for something like the following but does not work

[Business Focus].CurrentMember.[Second],
[Measures].[Issues resolved count] / [Business Focus].CurrentMember.[First],
[Measures].[Issues resolved count]

2

Hi,

The formula for this percentage calculation can refer to the member’s parent like this:

[Measures].[Issues resolved]/
([Measures].[Issues resolved],
 [Business Focus].CurrentHierarchyMember.Parent)

Note to use the “Decimal percentage” formatting for this calculation.

Kindly,