Clearing filter context from key column

Hi Anonymous ,

For the difference between ALL(column) and ALL(table), you can check this blog:

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI.

Then in your scenario, try this:

total =
CALCULATE (
    [sales_measure],
    TREATAS ( ALL ( 'fact'[color id] ), 'Dim'[Dim color id] ),
    ALL ( 'fact'[color id] )
)

Here's my test example:

Reference: TREATAS function - DAX | Microsoft Docs

Best Regards,

Icey

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