Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX ALL Function not working as expected

Hello,   I have a fairly basic problem that doesn't seem to rectify itself where I am trying to remove a filter context through the ALL() function, but the measure ignores this command and I do not...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

try

Day Average Rack = 
    CALCULATE( 
        AVERAGE(Table1[Rack]), 
        ALLEXCEPT(Table1, Table1[date])
    )