I can't seem to understand the problem related to this Row Level Context. Please Help its Urgent

[mhanalyticspk]

Here is a matrix that I created with Customer Group name in the rows area , which is actually a 2nd Level of a Hierarchy which is Customer Subchannel -> Customer Groupname -> Customer Name. The slicers filter fine for the values FCA% and Bias% when I put one field of the hierarchy at a time in the Rows area of the matrix visual but when I add the Hierarchy I get unwanted values of
FCA % and Bias %.

• here is the picture with a +ve Bias ValueSelected in the slicer on the left and the Values being showed in the Bias% column are correct while there is only one Field in the Rows as: 
  +ve Bias = Bias% >10%
  -ve Bias = Bias% <-10%
  unBiased = Bias% bwn -10% and 10%
  
• and here is the picture when I add the Hierarchy, in the blue. The Value showed in the red is a wrong Value.   I have rechecked all my measures but i don't seem to find the Problem.
  
  
  These are the Measures Used as per theory of Forecast Accuracy and Biasing
  

Actuals 2 = Calculate(SUM(Sheet1[ACTUALS]))

Forecast 2 = CALCULATE(SUM(Sheet1[FC]))

Error 2 = Calculate([Actuals 2]-[Forecast 2])

Bias% 2 = calculate(IFERROR([Error 2]/[Actuals 2],1))

FCA% 2 = Calculate(1-ABS([Bias% 2]))

• Two custom Tables are made for construction of the slicers.
  
  

   

  The Measures used for the Slicers are below:

Bias Slicer Measure = SWITCH(TRUE(),
[Bias% 2] >= .10 , 1,
[Bias% 2] <= -.10 , 2,
0
)

FCA Slicer Measure = SWITCH(TRUE(),
[FCA% 2] >= 0.84 , 1,
[FCA% 2] < 0.84 ,0)

Bias Filter = Switch(TRUE(),
SELECTEDVALUE('Bias Status'[Bias-Status])="+ve Bias" && [Bias Slicer Measure] = 1, 1,
SELECTEDVALUE('Bias Status'[Bias-Status])="-ve Bias" && [Bias Slicer Measure] = 2, 1,
SELECTEDVALUE('Bias Status'[Bias-Status])="UnBiased" && [Bias Slicer Measure] = 0, 1,
Selectedvalue('Bias Status'[Bias-Status])=BLANK(),1)

FCA Filter = Switch(TRUE(),
SELECTEDVALUE('FCA Status'[FCA-Status])="Good Accuracy" && [FCA Slicer Measure] = 1, 1,
SELECTEDVALUE('FCA Status'[FCA-Status])="Bad Accuracy" && [FCA Slicer Measure] = 0, 1,
Selectedvalue('FCA Status'[FCA-Status])=BLANK(),1)

​

and the Matrix Visual Filter Settings in the Filter Pane  are in the picture below

• Here is the Data Set

• and here is the Relationship view

Please Guide in this Matter

[lbendlin]

you say that the result is "wrong".  What do you expect to be the "right" result?