Forum Discussion

pwa42's avatar
pwa42
Frequent Visitor
5 years ago
Solved

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...
  • pwa42's avatar
    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 result

     

     lbendlin could not see this, the data sample was too small.

    Thanks for hints!