Urgent help- Dax

Hi, Anonymous 

Try to create a measure like this:

Measure = 
var _t1=CALCULATE(SUM('Table'[Value(int)]),'Table'[sublob]=BLANK())
var _t2=CALCULATE(SUM('Table'[Value(int)]),'Table'[sublob]=BLANK()&&'Table'[assetclass]=BLANK())
var _t3=CALCULATE(SUM('Table'[Value(int)]),'Table'[sublob]=BLANK()&&'Table'[assetclass]=BLANK()&&'Table'[geography]=BLANK())
var _t4=0  //whatever you want
// CALCULATE(SUM('Table'[Value(int)]),'Table'[sublob]=BLANK()&&'Table'[assetclass]=BLANK()&&'Table'[geography]=BLANK()&&'Table'[lob]=BLANK())

var _if=IF(
    ISINSCOPE( 'Table'[lob] ),
    IF(
        ISINSCOPE( 'Table'[geography] ),
        IF(
            ISINSCOPE( 'Table'[assetclass] ),
            IF( 
                ISINSCOPE( 'Table'[sublob] ), 
                SUM('Table'[Value(int)])// 0
                , 
                _t1// 1 
                ),
            _t2// 2
        ),
        _t3// 3
    ),
    _t4// 4
)
return _if

Result:

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.