cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

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

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

Super User

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

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.