Forum Discussion
pwa42
5 years agoFrequent Visitor
Inconsistent measure results
Situation: I was asked to create waterfall chart with starting and ending totals and dynamic structure of effects (breakdowns) - it should show different effects depending on position in organization...
- 5 years ago
Problem solved!
The main cause was that sets of effects for level 3 were not disjoint in some cases (Effect name Price was defined for more Parents). So when I used SELECTEDVALUE(T_Set_SimpleEbitda_effect[Parent]) to compare with single selected Code in hierarchy, it returned blank().
When I used VALUES instead of SELECTEDVALUE roblem was solved!
DF Simple Ebitda breakout = var selStructure = [Selected Hierarchy Code] var result = CALCULATE( if(selStructure in VALUES(T_Set_SimpleEbitda_effect[Parent]) , 1 , 0) ) return resultlbendlin could not see this, the data sample was too small.
Thanks for hints!
lbendlin
5 years agoSuper User
Then I am not surprised to see inconsistent results. SQLBI have a couple of articles on that, and RADACAD too. This is a rather complex topic.
pwa42
5 years agoFrequent Visitor
It seems that ragged hierarchy is a fake clue. I altered the hierarchy so it is comletely filled and the problem remains.
Any other ideas?