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!
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 result
lbendlin could not see this, the data sample was too small.
Thanks for hints!