Forum Discussion

melanie-g's avatar
melanie-g
Frequent Visitor
4 years ago
Solved

Allexcept not working

Hi there,   I have 2 models where my ALLEXCEPT calculation works in one but not the other.    Screen shots below of the model that does not work.    See below my calculation....   For y...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, melanie-g ;

    You can replace Allexcept() with Filter(allselected('table'),[group]=max('table'[group]))

    Check =
CALCULATE (
    SUM ( [MTD] ),
    FILTER (
        ALLSELECTED ( 'table' ),
        [eeCO_Desc] = MAX ( [eeCO_Desc] )
            && [eeBR_Desc] = MAX ( [eeBR_Desc] )
            && [eeDP_Desc] = MAX ( [eeDP_Desc] )
            && [eeFR_Desc] = MAX ( [eeFR_Desc] )
    )
)

     
    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, melanie-g ;

You can replace Allexcept() with Filter(allselected('table'),[group]=max('table'[group]))

Check =
CALCULATE (
    SUM ( [MTD] ),
    FILTER (
        ALLSELECTED ( 'table' ),
        [eeCO_Desc] = MAX ( [eeCO_Desc] )
            && [eeBR_Desc] = MAX ( [eeBR_Desc] )
            && [eeDP_Desc] = MAX ( [eeDP_Desc] )
            && [eeFR_Desc] = MAX ( [eeFR_Desc] )
    )
)

 
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.