Forum Discussion
Inconsistent measure results
- 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!
Is your hierarchy completely filled or ragged ?
it is ragged
- lbendlin5 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.
- pwa425 years agoFrequent Visitor
Well I am quite surprised, I would not expect to see this result. Even when the structure is ragged, i have 1 scalar result in measure [Selected Hierarchy Code]. Then I would expect consistent result when I filter by this result since there is no relation that would change the results.
Could you please link some of those articles you mentioned? - pwa425 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?