Managing “all” functions in DAX: ALL, ALLSELECTED ...
In this case, ALL is a filter parameter of CALCULATE. As such, it acts as a REMOVEFILTER, not as an ALL. When CALCULATE evaluates the filter in the denominator, it finds ALL. ALL requires the removal of any filters from the expanded Sales table, which includes Product[Color]. Thus, the filter is removed but no result is ever returned to CALCULATE.
DA: 21 PA: 81 MOZ Rank: 12 Up or Down: Up