Measure condition only with some levels of a drill down dimension

[lmb93]

Hi there!

I'm trying to set a measure that is on only when I'm on the bottom levels of a drill down dimension of the graph.

the drill down is world-region-country-area manager-salesman

I need that the second value on the combo graph work only on the last levels (area manager&salesman), not with the upper ones.

the drill down dimension name is: User

[vunguyenq89]

Hi,

You can use function GetObjectDimension() to check the current drill down level and decide whether to calculate the measure. For example:

=If(Match(GetObjectDimension(),'area manager','salesman'), Sum(Sales), 'Please drill down further')

Hope this helps,

BR,

Vu Nguyen

[lmb93]

Just tried but doesn't work 😞

the formula is

=If(Match(GetObjectDimension(),'area manager','salesman'),

((Sum([2019 YTD oe])/Sum([TARGET QTY oe]))+ if(isnull((Avg([Average of Correct Answer %]))),0,

            if(Avg([Average of Correct Answer %])>=0.94,0.1,

                        IF(Avg([Average of Correct Answer %])>0.84,0.06,

                                    IF(Avg([Average of Correct Answer %])>0.8,0.03,

                                                IF(Avg([Average of Correct Answer %])>0.07,'',

                                                            IF(Avg([Average of Correct Answer %])>0.64,-0.03,

                                                                        IF(Avg([Average of Correct Answer %])>0.59,-0.06,-0.1)

                    )

                )

            )

        )

    )

)) ,

'Please drill down further')

Any suggestions? Thank you